NOTE from JSOP: No, he is not using Excel.Interop. He's using something called ClosedXML - it's available here - ClosedXML - The easy way to OpenXML - Home[^]. Although his tag doesn't indicate as much, I suspect this is also for ASP.Net or MVC.
-------------------------------
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
What I have tried:
I tried to use the method range but not go