Convert excel file to image wrong

GemBox.Spreadsheet
1

This is the result of the convert and The drawing below is the original size

Dingtalk_20230921112034
Dingtalk_202309211120341825×806 164 KB

         var imageOptions = new ImageSaveOptions(ImageSaveFormat.Png)
		{
			PageNumber = 0, // Select the first Excel page.
							//Width = 980,
							//Height = 384,

			CropToContent = true // Export only the sheet's content.
		};

		workbook.Save(@"files/getbox.png", imageOptions);

What did I do wrong, thank you very much

2

Hi Sherry,

Can you send us your Excel file so that we can take a look at it?

Perhaps your sheet defines a print area that contains just that column “A”.
If that’s the case, you’ll need to either increase the print area or remove it:

var worksheet = workbook.Worksheets.ActiveWorksheet;
var printArea = worksheet.NamedRanges["_xlnm.Print_Area"];
if (printArea != null)
{
    Console.WriteLine($"The cell range of print area: {printArea.Range.Name}");
    // ...
}

Or perhaps you need to specify these options:

var worksheet = workbook.Worksheets.ActiveWorksheet;
worksheet.PrintOptions.FitWorksheetWidthToPages = 1;
worksheet.PrintOptions.FitWorksheetHeightToPages = 1;

Regards,
Mario

3

Ok, I will sent my file by email