Conversion of Excel Report to PDF Issue

Hi,

We have an issue with conversion of Excel report to PDF.

We have a prompt in UI to select required filters before generating report.

when user selects this filters, report works fine in excell. it filterout selected data from report but this would not work in PDF report. it shows all data in PDF report

Excel template has Aspose tags/cells and a macro and this macro used to filter the data in excel report after generate the excel report. when generating PDF this would not works.

Is there any way to achieve this in Excel (with out macro ) and PDF reports.

Thanks & Regards

Srinivas Musthyala

Hi Srinivas,

Thank you for considering Aspose.

Well, if the filtered data is obtained by a macro then Aspose.Cells for .NET does not allow this as it does not support to manipulate macros. I think you may try the Aspose.Cells autofilter APIs and see if they meet your needs and you may replace the macros with Aspose.Cells Auto filter options. Please see the following documentation link and online demo for your reference.

http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/data-filtering-and-validation.html

http://www.aspose.com/demos/.net-components/aspose.cells/csharp/quick-start/data/data-filter.aspx

If you need any further assistance please feel free to contact us anytime.

Thank You & Best Regards,