ReoGrid Forum

Fast and powerful .NET Spreadsheet Component

You are not logged in.

Announcement

This forum has been archived and no longer accepts new user registrations. Please report your questions, problems, and feedback to the issue page of ReoGrid on GitHub. Thank you for your cooperation.

https://github.com/unvell/ReoGrid/issues

#1 2015-09-15 09:07:56

san_943
Member
Registered: 2015-09-08
Posts: 8

Support for Excel 2003 (.xls)

Hi Jing,

Is there any way I can load Excel 2003 (.xls) file in reogrid control? Something like below:

workbook.Load(path, unvell.ReoGrid.IO.FileFormat.Excel2003);


Thanks.

Regards,
San

Offline

#2 2015-09-15 09:55:18

alexeyrlx
Moderator
From: CIS
Registered: 2015-07-14
Posts: 36
Website

Re: Support for Excel 2003 (.xls)

Specify the format xls (Excel 97-2003) is absolutely not similar to xlsx (Excel 2007/2010).
Therefore, the support of this format can permanently slow down the development of other functions Reogrid.

If you use Excel 2003, you can try a special converter from Microsoft.
https://www.microsoft.com/en-US/downloa … .aspx?id=3

It is built into your office suite, added support of new formats into dialog boxes for opening and saving files.

There may be a problem with tables that contain more than 65,536 rows (restriction for Excel 2003)

Last edited by alexeyrlx (2015-09-15 10:09:16)


My English is perfect! (My version of the English language ;-) )

Offline

#3 2015-09-16 06:37:16

san_943
Member
Registered: 2015-09-08
Posts: 8

Re: Support for Excel 2003 (.xls)

Hi,

I know that I can open Excel 2007 files in Office 2003 using the compatibility software. My question was "Is it possible to load .xls file in ReoGrid Control ?".
If yes, how can I do that since I cannot see any way by which I can load a .xls file in ReoGrid.

Please suggest.

Thanks.

Regards,
San

Offline

#4 2015-09-16 08:42:48

alexeyrlx
Moderator
From: CIS
Registered: 2015-07-14
Posts: 36
Website

Re: Support for Excel 2003 (.xls)

Hi,
Reogrid don't support a format xls (Excel 97-2003).
It is impossible to load .xls file in ReoGrid Control

Last edited by alexeyrlx (2015-09-16 08:45:46)


My English is perfect! (My version of the English language ;-) )

Offline

#5 2015-09-26 00:29:50

Jingwood
Moderator
From: jing at reogrid.net
Registered: 2014-06-03
Posts: 615

Re: Support for Excel 2003 (.xls)

As alexeyrlx said ReoGrid doesn't support Excel 97-2003 format, and we currently haven't plan to make it available.

Maybe use some third-party components is the only way, such as NPOI? Open the Excel 97 file using NPOI, read all data and fill into ReoGrid control.

Offline

Board footer

Powered by FluxBB