ansaurus

Question

Answer 1

+1 A:

XSLT is mostly used to convert XML from one dialect to another, not to convert xls files to html.

If you just want to do this manually, you can save your worksheet as HTML directly in excel.

It is not clear from your question if you want to do this programmatically, and if so using what programming language.

Oded 2010-01-29 09:08:44

Thanks for your feedback. I just updated question with the info that I would like to have it done automatically. And that if xslt cannot read xls then some C# code can be used for the job or just to convert xls to xml

Tillebeck 2010-01-29 10:41:52

Answer 2

A:

You can use ADO.net to access cells in an excel file, similar to a DB query. This is a bit lighter than trying to use Excel automation objects.

http://support.microsoft.com/kb/316934

Paddy 2010-01-29 09:18:16

thanks for the link. I will come back to it. But is it correct that it is about code going into the excel sheet? If possible in any way I would love to make the xslt ablo to retrieve the data from an xls-file. But if not possible another solution must be made.

Tillebeck 2010-01-29 10:44:31

As said above, you could save your worksheet as another format, but otherwise you will need to do some programming. Of course, you could just server the excel file directly...

Paddy 2010-01-29 11:00:47

Answer 3

A:

SpreadsheetGear for .NET can read Excel files and display them in a DataGrid as shown in the Excel to DataGrid sample on this page:

    // Create a workbook from an Excel file
    String ssFile = Server.MapPath("files/spiceorder.xls");
    SpreadsheetGear.IWorkbook workbook = SpreadsheetGear.Factory.GetWorkbook(ssFile);
    // Get a DataSet from an existing defined name
    DataSet dataSet = workbook.GetDataSet("orderrange", SpreadsheetGear.Data.GetDataFlags.FormattedText);
    // Bind a DataGrid to the DataSet
    DataGrid1.DataSource = dataSet;
    DataGrid1.DataBind();

SpreadsheetGear can also render png/gif/jpg images from cell ranges or charts as demonstrated here.

You can download the free trial here if you want to try it yourself.

Disclaimer: I own SpreadsheetGear LLC

Joe Erickson 2010-01-29 18:47:46

Thanks for the tip. I cannot do any C#, so some company will have to do that part. I will send them the link to this thread so they will get to know your product. Hope sales are doing well ;-)

Tillebeck 2010-02-01 08:49:59

ansaurus

tags:

views:

answers:

Output table from excel using xslt

related questions