i am trying to find a way to create large complex excel docs very quickly and i think that aspose might be my solution. but i need to know what to expect regarding speed - so i have 3 questions:
1. approximately how quickly should i expect to be able to dump an dataset 2,500 rows by 20 columns big into a single sheet (a design document) and have it save to file?
2. approximately how quickly should i expect to be able to make 100,000 individual cell value inserts into a single sheet (design doc) and then save it to file?
3. if i had 2 sheets in my design doc, one for importing values and a second that had cell references to the first, and then i imported a 2,500 row by 20 col dataset into the first sheet, then saved the second sheet to file (as values ONLY) would it be quick? slow? problems?
we tried an initial test of import from data table and it was very slow - 15-20 seconds for 2,500 rows, 10 columns.
thanks for your help.