Using Web query to fetch data from Web to Excel

Aspose.Cells Product Family
1

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

2

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

3


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

4

Hi,

Thanks for your posting.

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