Comments (5)
By default, a new worksheet in ReoGrid is initialized with 200 rows and 100 columns. Given your text file has 400 rows, you'll need to explicitly set the number of rows in your target worksheet to accommodate all the data from your file before loading the data.
worksheet.Resize(400, 74);
from reogrid.
Yes, this helps, Thank you @jingwood but now I end up in new error in later part of code. While writing data in my target excel file which is .xlsx file that contains Pivot tables using this data. After loading data in Excel Sheet, if I open Excel file Excel complains
If I select Yes, it deletes all existing Pivot tables and only retains 1 blank sheet and target sheet with data in the same.
Does this saving is not possible in ReoGrid, were only data is loaded, or it is related to option used
grid.Save(excelFilePath, unvell.ReoGrid.IO.FileFormat.Excel2007);
is breaking original sheet. Is there any available way out?
Thanks in advance.
from reogrid.
I can't help without more information about the error. If possible can you please share the Excel file?
from reogrid.
I use GeoGridControl. The Load () method loads excel file to GeoGridControl control, prompt System. ArgumentOutOfRangeException:"
from reogrid.
from reogrid.
Related Issues (20)
- how to get cell with column or row header text?
- How to extract the exact value?
- How to add a column to the left of the Column Header, How to add rows on the RowHeader HOT 1
- Context menus on ReoGrid WPF
- WinUI 3 Support
- performance issue HOT 3
- How to adjust column order by dragging and dropping columns HOT 2
- dropdownlist item missing while save/load rgf file
- Does ReoGrid have function to show cell note?
- How to implement CheckBox cell type for entire column. HOT 6
- Hello, just want to ask...
- data exception HOT 1
- CSV file loading issue HOT 1
- Are there any plans to support Avalonia? HOT 2
- About the sheet Name display in the lower left corner HOT 4
- when i use ReoGridControl.Load() method to load excel Templates. error occurred: System.ArgumentOutOfRangeException:“capacity was less than the current size. Arg_ParamName_Name” HOT 1
- How to know the coordinates of "Graphics. Point" in "RangePosition" or "CellPosition" HOT 2
- about images
- easy way to put a mask for input in cell HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from reogrid.