How to import an Excel Spreadsheet into Essential Grid

[Administrator]

I am attempting to convert an old Excel application into a C# application. It would appear that with a combination of Essential Grid and xlsIO I have everything I need, but now I''m starting to wonder...

Is there a way to easily import an Excel spreadsheet, formatting and all, and save it in Essential Grid''s XML format? I saw a similar question in the xlsIO forums, but they are a few months old, and I wasn''t sure if this had been added yet.

Many thanks,

Taylor

[Administrator]

Hi Taylor, I apologize for the delay in replying. The GridExcelConverterControl class that shipped with version 4.1 of essential grid can import an MS Excel worksheet into the Grid with most of the formats. The cell styles can also be retrieved from IRange.CellStyle. Please refer the sample. Regards, Calvin.

ExceltoGridconverter.zip