Internet Excel files

xlsgen > overview > Internet Excel files

Excel files not always live in hard drives in someone's PC. Sometimes they are available from the internet, and they are identified by a URL or behind a wall of some specialized service (such as Dropbox or Microsoft OneDrive).

xlsgen makes it possible to download and open Excel files by specifying this URL in the Open() method call. Here is a sample code :

Excel file identified by a URL

Java code

// open an Excel file identified by its URL
XlsWorkbook workbook = engine.Open( "http://xlsgen.arstdesign.com/core/Book1_chart20.xls", "" );
//...
workbook.Close();

VB code

' open an Excel file identified by its URL
IXlsWorkbook workbook = engine.Open( "http://xlsgen.arstdesign.com/core/Book1_chart20.xls", "" )
'...
workbook.Close

C# code

// open an Excel file identified by its URL
IXlsWorkbook workbook = engine.Open( "http://xlsgen.arstdesign.com/core/Book1_chart20.xls", "" );
//...
workbook.Close();

C++ code

xlsgen::IXlsEnginePtr engine( __uuidof(xlsgen::CoXlsEngine) );

// open an Excel file identified by its URL
xlsgen::IXlsWorkbookPtr workbook = engine->Open( L"http://xlsgen.arstdesign.com/core/Book1_chart20.xls", L"" );
//...
workbook->Close();

What xlsgen does is, as expected, download the file in memory and open it. The Excel file is not stored in a cache in the hard drive.