While testing with some larger PDF files (10MB to 20MB each) to create XLS, I’m facing enormous spreadsheet filesize (>400MB).
But if I open this enormous file with Excel and “save as” another file, it get reduced to the expected ~10MB filesize.
I’m using the most updated versions:
Aspose.Net 23.8.0
Excel version 2307 build 16626.20170
Sample:
Input file: 8MB
input_file.7z (4.6 MB)
Output XLS: 434MB
output_file_v0.7z (2.3 MB)
XLS open/save-as: 5.8MB
output_file_v1.7z (5.5 MB)
C# code:
var inputFile = Request.Files[i];
// Load PDF with an instance of Document
var document = new Document(inputFile.InputStream);
var extension = Path.GetExtension(inputFile.FileName);
var filename = inputFile.FileName.Replace(extension, "") + "_" + dataAtual.ToString("yyyy.MM.dd-HH.mm.ss") + ".xlsx";
var dataSave= new ExcelSaveOptions { MinimizeTheNumberOfWorksheets = true };
var filepath = ConfigurationManager.AppSettings["outFolder"].ToString() + filename;
// Save document in XLS format
document.Save(filepath, dataSave);