I would like to display Excel SpreadShee开发者_开发问答t on the webpage. Seems like when I am using ADO.NET I can only access to data but is there some way so I can also know which rows/cols are formatted in special way like headers?
You can to use Open XML SDK 2.0 for Microsoft Office
SpreadsheetGear for .NET can render a range of cells, or a chart, as an image with custom number formats, fonts, colors, borders, charts, etc...
You can see some live ASP.NET samples (C# and VB) of this here and download the free trial here if you want to try it yourself.
Disclaimer: I own SpreadsheetGear LLC
精彩评论