Excel PDF Converter Header Footer

Aspose.Cells Product Family
1

Hi,

We tried to convert excel document to PDF and header/footer is missing in the output document (Attch. Test.xls and Test.pdf)

In second test we tried to convert some charts and the charts are missing in the pdf document (Attch. charttest.xls and charttest.pdf).

Thanks

2

I only find the test.pdf file. Could you zip other files and post them here again? Thank you.

And are you using the latest v4.3? Please try it.

3

Hi,

I attached the documents in a zip file. We are using 4.1.2.1 (Assembly Version). We will try with the latest.

Thanks

4

Hi,

We tried the latest version of ASPOSE.Cells and ASPOSe.PDF.

The header/footer issue is resolved but when we try to convert charttest.xls we got the following error

Value cannot be null, Parameter name: enumType at the following line

workbook.Save(strFileName, Aspose.Cells.FileFormatType.AsposePdf)

Same code worked for Test.xls document

Thanks

5

Hi,

I don't find charttest.xls file. Could you please post us your charttest.xls file here, so that we may check and resolve your issue soon.

Thank you.

6

Hi,

Please Check the attachment

Thanks

7

Hi,

Well, I checked your chart test.xls file. Since your file contains Area, XY(Scatter) and Surface charts which are not completely supported for xls2pdf converion. We will support them soon enhancing xls2pdf conversion. Currently, Column, Bar, Line and Pie charts with 2-D are completely supported.

Thank you.

8

Hi,

Could you please make sure that if a particular chart type is not supported then ignore that in the output document instead of throwing an error so if I have two charts in the same document and one is supported then I should see one chart in the output document.

Thanks

9

We will check and fix this issue soon.

10

Hi,

We tested "chart test.xls" and it works fine. Please try the lastest version 4.3.

Now Aspose.Cells supports to convert all 2D charts to image . And we are working with 3DChart2Image.

11

Hi,

Please try this fix.

We re-check this file with the DLL and we get the same error as yours .We have fixed it now.

12

Hi,

Is this DLL for .NET framework 1.1 OR 2.0. We are using framework 2.0.

Thanks

13

It's built on .net1.0 but it works fine in .net1.1 and .net2.0.

14

Hi,

Now there is no error. Thats Great!! but still there is some issue. Only first two charts match in the input and output document and rest of the charts are different in PDF than in xls file. Is it possible to ignore conversion instead of some different chart.

Attch. Charts.zip

Thanks

15

Hi,

Since your third, fourth and sixth charts are 3-D Area, 3-D Pie and 3-D Surface respectively. Currently we don't support the 3-D charts as we are working on it and it will be available soon. For complete list of supported charts please check: Converting Chart to Image

if a chart is not supported, it will get a column / bar like shape in the output file.

Thank you.

16

Please try this attached fix. It will ignore unsupported charts.