- Code: Select all
CellRange source = ws.Range[first_table_row, 1, last_row_used-1, ws.LastColumn];
PivotCache cache = workbook.PivotCaches.Add(source);
var wsPT = workbook.Worksheets.Create("Сводная1");
PivotTable pt = wsPT.PivotTables.Add("Сводная1", ws.Range["A2"], cache);
Im marked column 20 in the file. If i delete it - it will be OK, file after making Pivot opens without any errors. Difference of this column - there are floating point numbers. GetCellType of thet column gives "Number". May be comma (RU culture format numbers) causes that problem. How can i FIX it?
P.S. try to change system standard of floating point from "," to "."...nothing changed