Save a worksheet As a Html


#1

How can I save a worksheet as a html page. Better yet. is it possible to expert a workseet into a string (c#) in html format?


#2

Currently Aspose.Excel doesn’t support to export file as html format. We will implement this feature but it will take about several months.


#3

So, there is no way to display the Aspose.Excel object in any other way but useing the MS Excel, which is what I tried to avoid in the first place.


#4

Yes. Aspose.Excel is a spreadsheet creation engine to generate file with native excel format. So you have to use MS Excel or ExcelViewer to display the result file. But please keep an eye on our product. We are working on html issue and display control.


#5

I will certainly use them as they become available. The problem is they are months away. What ExcelViewer are you referring to?


#6

When do you excpect the html and the display functionality to be available? The ExcelViewer is not very usefull form my purpose.


#7

Hi Roman,

If you want to display the content of an Excel file, you can also try a workaround. You can make the UI by yourself and bind the data in Excel object. Aspose.Excel supplies several ways to export data in the file. Please refer to Cells.ExportDataTable,Cells.ExportDatable and cell properties.


#8

I’m guessing the ExportDatable will produce an “N x N” table of data. This falls short of what I need.

I need all the cell-merging, bolding, and cell-colors of my Excel file preserved into a fancy HTML table. My clients won’t necessarily have Excel, so I need to dump a file on the screen as HTML (formatting and all).

Is there any option that will be available in the next 30 days that will do this?

Thanks for any help you can give me :slight_smile:

Sam


#9

Hi Sam,

We are working on a new Excel Web Control to display contents of Excel file with all styles and format. But it’s complex and the planned release date will be someday in September.


#10

Sam, did you come up with a solution? Any ideas? I am in the same situation as you are. My clients migh not have an Excel installation.


#11

Laurence,

Do you have any code examples for the Cells.ExportDataTable,Cells.ExportDatable and cell properties.?

Roman


#12

No, but I did find a simple algorithm searching google that would create an HTML with horizontal cell merging, border, and background color. It was in C# (+?) But I can’t find it again. :frowning:
It was far from perfect, but honestly, if you add vertical cell merging & row/col widths, its all I need.

Actually, I may have it in source safe… I’ll see if I can find it.

Any help (from anyone) is much appreciated!

-Sam


#13

We are working on a new web control to display contents of Excel file. It will be availabe at the start of September. Now thanks for your patience.

Now you can try the following workaround :
1. You can put a Datagrid in your web page
2. Bind data with DataTable exported with ExportDataTable method
3. Set the style in the Datagrid

Sample code about ExportDataTable can be found at http://www.aspose.com/Products/Aspose.Excel/Guide/ImportExport.html.