@FunctionalInterface public interface FreeLimitReachedListener
SpreadsheetInfo
Following code demonstrates one way of testing performances of GemBox.Spreadsheet.
SpreadsheetInfo.setLicense("FREE-LIMITED-KEY");
SpreadsheetInfo.addFreeLimitReachedListener(args -> args.setFreeLimitReachedAction(FreeLimitReachedAction.CONTINUE_AS_TRIAL));
long start = System.nanoTime();
ExcelFile ef = ExcelFile.load(fileName);
long elapsed = TimeUnit.NANOSECONDS.toMillis(System.nanoTime() - start);
System.out.println("Load time: " + elapsed + " milliseconds.");
start = System.nanoTime();
int cellWithValueCount = 0;
for (ExcelWorksheet sheet : ef.getWorksheets())
for (ExcelRow row : sheet.getRows())
for (ExcelCell cell : row.getAllocatedCells())
if (cell.getValue() != null)
++cellWithValueCount;
elapsed = TimeUnit.NANOSECONDS.toMillis(System.nanoTime() - start);
System.out.println("Iterate through all used cells time: " + elapsed + " milliseconds. Cells with value: " + cellWithValueCount);
start = System.nanoTime();
ef.save(fileName);
elapsed = TimeUnit.NANOSECONDS.toMillis(System.nanoTime() - start);
System.out.println("Save time: " + elapsed + " milliseconds.");
Modifier and Type | Method and Description |
---|---|
void |
onFreeLimitReached(FreeLimitEventArgs arguments)
The method is called when the free limit is reached
|
void onFreeLimitReached(FreeLimitEventArgs arguments)
© GemBox d.o.o. — All rights reserved.