This project has moved and is read-only. For the latest updates, please go here.

How to take part in excel files because when I save the file increases

Dec 15, 2016 at 10:45 AM
Hello sorry for my english. I have to select a row of a excel file, put any new data and save them. In the end I see that the excel file is always larger than before although the data are not increased but it looks to be created of the blank columns to the right. I think this because when I execute the following statement
var wb = openWorkBook(filename);
var ws = wb.Worksheet("CNF");
IXLRow row = ws.Row(device.Ordinal - 1 + FirstRow);
for (int j = 0; j < 100; ++j)
{
IXLCell cell = row.Cell(j + FirstCol);
...}
as range goes from A1 to XFD1048576. Although after I take the line of my interest and cycle of 100 columns when I go
wb.Save();
the file increases.
In the file it seems to be created empty right columns that increase the file size.
If I then draw attention to the empty columns and delete the file back to its previous size.
So I ask you if you have a method to take only a part of a file then for example take already suffered from a limited number of columns, starting from education
var ws = wb.Worksheet("CNF");
Thank you