What formats of Excel file are supported?
ReoGrid supports Excel 2007 (and later) format, as well as other OpenXML-based spreadsheet format, such as OpenXML SDK-generated spreadsheet file and some open-source/free office applications-generated spreadsheet file. Excel 97-2003 format is not supported, and there is no plan to make it available in future versions.
How to fill worksheet with a DataTable? See answer.
How to make entire worksheet read-only?
By setting the worksheet settings worksheet.SetSettings(WorksheetSettings.Edit_Readonly, true); to make entire worksheet read-only.
How to know how many rows and columns of the data on given worksheet?
To get number of rows and number of columns of the data on worksheet, use property MaxContentRow and MaxContentCol of worksheet.
How to disable selection?
Setting the SelectionMode property of worksheet instance to None will disable selection on worksheet.
How to clear the selection?
Setting the SelectionMode to None will make focus selection range disappear, select it back to Range will restore it, but notice that selection range will only be restore at first cell.
How to iterate over all cells in range or worksheet? To iterate over range or worksheet, use method IterateCells of worksheet and pass a range position argument. Notice that this method skips empty cells on worksheet. If don’t want to skip empty cells, use for-each on Cells property of ReferenceRange instance. To get an instance of ReferenceRange, use code like worksheet.Ranges["B1:D5"]. Notice that Cells property will create cell instance if the cell is empty, this will cause many memory use if the range is large.
How to find text over multiple cells?
Use the IterateCells method to iterate over cells on worksheet or range, check the Data property of cell instance to find text.
How to delete the specified cell’s content at one time, such as styles and borders?
To remove cells content, use the method ClearRangeContent method. This method deletes the content that is specified by secondary argument CellElementFlag. To remove only styles, use RemoveRangeStyles method; To remove only borders, use RemoveRangeBorders method.
Can I use ReoGrid in WPF?
Yes, from the version 0.8.7 ReoGrid can run in both Windows Form and WPF platforms, for the details please check here.
ReoGrid supports multiple worksheet, but I want to make it only one worksheet available, can I do that?
Yes, by hiding the built-in sheet tab control to prevent that end user adds or removes worksheets. See built-in sheet tab control.
Can I open Excel file, modify it, and save it back without creating a visible control on form?
Yes, ReoGrid memory workbook provides almost all features to operate Excel file or RGF file without a visible control on form. Use ReoGridControl.CreateMemoryWorkbook to create the instance of memory workbook.
How to read all images from Excel file?
Handling images from Excel file is available in ReoGrid Pro-edition. See Read all images from Excel file.
Can I print all worksheet at a time?
Yes, print single worksheet available in free-edition, print all or specified worksheets available in ReoGrid Pro, see Paging and Print.
License
What is the release license of ReoGrid?
ReoGrid is open source software released under MIT License.
Can I use ReoGrid in proprietary software or commercial software?
Yes, you can.
Hi! It’s possible to specify a range that is only available for editing by handling event. The version 0.8.8 supports that export the spreadsheet as Excel, CSV and HTML format. You will find more example code in Demo project.
It’s very much pleased that I can use ReoGrid for my application, Could you share me the next release date?
And I found another issue, if I export a excel(*.xlsx) file from ReoGrid, then I open it by MS OFFICE 2010, it always popup a alert dialog, it says some unreadable content, and ask me “if recover the workbook or not, click ‘YES’ …… “, after I click YES, office excel prompt ‘have deleted part of style of /xl/styles.xml’.
And it works well except the popup. Maybe it cause by the compatibility between OFFICE 2007 and 2010
Hello! I very like this tools,but I found a problem, the dropdowncellbutton auto change height when I change the cell’s height, I saw your page about “Dropdown Cell”,buy I can’t found the “DropdownButtonAutoHeight” property ,can you help me? thany you very much!
Hi! The LGPLv3 open source ReoGrid (linked in your comment) is an old version of this component (before 0.8.6.0). From 0.8.6.0 except the core library all code become BSD license, core library changed to closed-source free software license. After 0.8.6.0 there is many new features available for free, such as Excel format, WPF version, enhanced cells freeze, printing functionality and new formula engine.
Hi. Excel .xls format is not supported. You can open Excel 2007 and later (.xlsx) format into the control, makes changes and save it back. Some settings to the Excel file may lose if they aren’t supported by ReoGrid. https://reogrid.net/document/excel-file-format/
Ah! Thanks.
I had tried Excel 2007 too but it failed. I realise now that it probably failed because I loaded a spreadsheet with formatted text in it which displays on-screen but obviously causes it to fail when saving or printing because I’m using the free version which doesn’t support rich text.
A shame because I can’t justify $760 for the full version just for the sake of rich text (thats more expensive than Crystal Reports)
Hi. Your ReoGrid is very great and useful. I can not print when the ReoGrid is applied to WPF. The case given in the website is ony applicable to WinForm.
Hi,a weird problem is occured when I use the print function of reogrid. There is always blank area in the right side of page, no matter I change margin-left and margin-right.
Hi, if I buy one license, will this activate the ReoGrid Pro in just one computer? and if I want to use it in two different machines must I buy two licenses?
Is it still closed source? I’m missing some customization regarding AutoFillSerial and went to the forums for help. Funny enough I saw the suggestion to the change the source code, as an answer to a similar question I was about to ask. So I googled for source code and found Reogrid on Github: https://github.com/unvell/ReoGrid/tree/0a286679199ebc0f9a090d9471d951cdca691d07
The MIT license matches, the version number and the support for WinForms, WPF and Android. So I was wondering, is your reply to Jeffrey Kesselman in 2015 still up relevant? Or have you gone back to open source again in the meantime?
It’s fully open source software since 2017, under MIT license. The source code on Github is the latest version. What is your question? You can post it at https://github.com/unvell/ReoGrid/issues
Ok, cool! Might I suggest you change the text at the top of this FAQ page. At the heading ‘License’ it mentions Reogrid is closed source.
I’ll post my issues and questions to github if I find any worth bothering you about. Right now I’m just toying around and don’t want to make an issue out of everything. Short version: I was looking for supplying custom incrementing behaviour when using AutoFillSerial for custom cellbody’s and/or custom datatypes. I looked at the source, and there appears to be no support for it. So my question is answered. 🙂
I have two sheets not in the same workbook, the second sheet has formulas referencing to the first. When i add the second sheet in the workbook of the first sheet, the cells that have formula with reference do not update, but they still have the formula, if i copy/paste the formula in different cell it works. I tried .recalculate but that doesn’t help.
Hi.. I Have A Question?
Is it possible for me to Somehow Not Allow The User To Edit Any Cells Although He can select them and copy the values too,,,
Also Can i Export and import my table or data…
Thanks!!
Hi! It’s possible to specify a range that is only available for editing by handling event. The version 0.8.8 supports that export the spreadsheet as Excel, CSV and HTML format. You will find more example code in Demo project.
If you have more questions please post them in forum: https://reogrid.net/forum, thanks!
How to use the workbook.DoDragDrop() function?
MAX and MIN formula is not available, like this “=MIN(A1:H1)”, get the min item from A1 to H1,
MIN(A1,B1,C1) works well
Thanks for the information! We have also noticed this problem and planned to fix it in next version.
It’s very much pleased that I can use ReoGrid for my application, Could you share me the next release date?
And I found another issue, if I export a excel(*.xlsx) file from ReoGrid, then I open it by MS OFFICE 2010, it always popup a alert dialog, it says some unreadable content, and ask me “if recover the workbook or not, click ‘YES’ …… “, after I click YES, office excel prompt ‘have deleted part of style of /xl/styles.xml’.
And it works well except the popup. Maybe it cause by the compatibility between OFFICE 2007 and 2010
This problem has been resolved and tested, and will be released in 0.8.9.1-alpha version.
Hello! I very like this tools,but I found a problem, the dropdowncellbutton auto change height when I change the cell’s height, I saw your page about “Dropdown Cell”,buy I can’t found the “DropdownButtonAutoHeight” property ,can you help me? thany you very much!
Hi! Please check the latest version 0.8.9.2 at https://reogrid.net/download/
Is there a renewal price for ReoGrid pro or is it the same amount every year?
Hi! We offer discount for renewal license, for more please refer to Renewal Price at https://reogrid.net/purchase.
Regards, Jing
What is the difference between your product and the LGPL’d open source REO grid?
http://www.codeproject.com/Articles/691749/Free-NET-Spreadsheet-Control
Hi! The LGPLv3 open source ReoGrid (linked in your comment) is an old version of this component (before 0.8.6.0). From 0.8.6.0 except the core library all code become BSD license, core library changed to closed-source free software license. After 0.8.6.0 there is many new features available for free, such as Excel format, WPF version, enhanced cells freeze, printing functionality and new formula engine.
How do I iterate over all the defined border ranges in a worksheet?
Answered at https://reogrid.net/border.
Thank you!
Hi. Can I open an existing xls or xml spreadsheet into the control, make some changes to data, and then save it back to the file?
Hi. Excel .xls format is not supported. You can open Excel 2007 and later (.xlsx) format into the control, makes changes and save it back. Some settings to the Excel file may lose if they aren’t supported by ReoGrid. https://reogrid.net/document/excel-file-format/
Ah! Thanks.
I had tried Excel 2007 too but it failed. I realise now that it probably failed because I loaded a spreadsheet with formatted text in it which displays on-screen but obviously causes it to fail when saving or printing because I’m using the free version which doesn’t support rich text.
A shame because I can’t justify $760 for the full version just for the sake of rich text (thats more expensive than Crystal Reports)
Hi. Your ReoGrid is very great and useful. I can not print when the ReoGrid is applied to WPF. The case given in the website is ony applicable to WinForm.
Hi! Thanks for your feedback! We’d like to solve the print problem of WPF edition in future versions.
For the print problem, I can swtich to the WinForm. But another problem is occured. The event of DoubleMouseClick can not handled. Can you help me?
Luckly, I have solved this problem just catch the event of DoubleClick not MouseDoubleClick. Thanks to your ReoGrid!
Well done! If you have other problems please let us know.
how can i get the info of a grid into data table or database
You have to get the data from every cells and insert the data into database.
Hi,a weird problem is occured when I use the print function of reogrid. There is always blank area in the right side of page, no matter I change margin-left and margin-right.
Can you provide a picture for this? You can link it in forum: https://reogrid.net/forum
Hi, if I buy one license, will this activate the ReoGrid Pro in just one computer? and if I want to use it in two different machines must I buy two licenses?
Yes if you use in two computers at same time, you need two licenses.
Is there drag-n-drop in ReoGrid?
Yes you can drag and drop cell or range.
Hi, how can i use filter in WPF? I tried to use filter in WPF, and it’s not working, then i tried to use it in the windows form, it’s work perfectly.
Is it still closed source? I’m missing some customization regarding AutoFillSerial and went to the forums for help. Funny enough I saw the suggestion to the change the source code, as an answer to a similar question I was about to ask. So I googled for source code and found Reogrid on Github:
https://github.com/unvell/ReoGrid/tree/0a286679199ebc0f9a090d9471d951cdca691d07
The MIT license matches, the version number and the support for WinForms, WPF and Android. So I was wondering, is your reply to Jeffrey Kesselman in 2015 still up relevant? Or have you gone back to open source again in the meantime?
It’s fully open source software since 2017, under MIT license. The source code on Github is the latest version. What is your question? You can post it at https://github.com/unvell/ReoGrid/issues
Ok, cool! Might I suggest you change the text at the top of this FAQ page. At the heading ‘License’ it mentions Reogrid is closed source.
I’ll post my issues and questions to github if I find any worth bothering you about. Right now I’m just toying around and don’t want to make an issue out of everything. Short version: I was looking for supplying custom incrementing behaviour when using AutoFillSerial for custom cellbody’s and/or custom datatypes. I looked at the source, and there appears to be no support for it. So my question is answered. 🙂
Thanks! Page is edited.
I have two sheets not in the same workbook, the second sheet has formulas referencing to the first. When i add the second sheet in the workbook of the first sheet, the cells that have formula with reference do not update, but they still have the formula, if i copy/paste the formula in different cell it works. I tried .recalculate but that doesn’t help.
Hi,
is DDE (or RTD) as stock market data-feed supported ?