Hi everyone,
My goal is to save a very larger amount of data (something around 1.000.000 rows) in one excel file. I read a lot about this problem and it seems like LightCellsDataProvider is a correct path for me. I tested it and it really works very fast, and does not take much memory. Only problem that I have now is…how to store data column by column and not row by row… With simple implementation (no LightCells) I can just do a loop in loop like that:
for (int j = 0; j < rowCount; j++){
for (int i = 0; i < 15; i++){
Cell cell = cells.get(j, i);
cell.setValue("Test"+counter++);
}
}
And decide what order I want to choose - e.g. fill in column by column. Now with LightCellsDataProvider I think that a order of filling data is fixed - row by row, am I right ? I added some loggin into the LightCellsDataProvider so I can see the order of calls, and it tells me that I am right:
startSheet
nextRow
startRow
nextCell
startCell
nextCell
startCell
nextRow
My question is : it there a way to use LightCells and store data column by column and not row by row ?? It is very important in my project to do it in this order. BTW I am using JAVA and AsposeCells 7.3.1
Any information will be very helpfull…
cheers