We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Using Web query to fetch data from Web to Excel

I have been using Aspose.Cells to export my data into Excel.
However, for a HTML to be seen in Excel, I can’t see the CSS.
I literally have to get the data from the server and paint it using Aspose and then apply my own CSS.
There’s a way, we can import the Web pages into Excel. It gets the CSS as well. Is it possible to do this using Aspose. If its possible how do I do it else is there a work around for my problem. It would be of great help and would save a lot of my effort.

Regards,
Aslam

Hi,

Thanks for your posting and using Aspose.Cells.

You will have to apply the html formatting yourself.

Aspose.Cells for Java provides you APIs how to apply cells’/columns’/rows’ formatting

Please see the following section and subsections
Aspose.Cells for Java —> Working with Data Formatting


and there is no insertHTML ind of thing available in Aspose.Cells like we have in Words. It’s a real pain for me to write codes to fetch the data from the server to build the HTML that needs to be exported to Excel. And if we can do it using Excel (the Web query stuff) it would be possible for Aspose to do it as well. Do we have this planned for any of the further releases.

Please suggest.

Regards,
Aslam

Hi,

Thanks for your posting.

You can add formatted html inside the cell using Cell.setHtmlString().