Different Ways to Open Files

With Aspose.Cells it is possible to open files, for example to retrieve data, or to use a designer template to speed up the development process. Aspose.Cells can open a range of different files, such as Microsoft Excel spreadsheets (XLS, XLSX, XLSM, XLSB), CSV or TabDelimited files.

Opening a File via a Path

Developers can open a Microsoft Excel file using its file path on the local computer by specifying it in the Workbook class constructor. Simply pass the path in the constructor as String. Aspose.Cells will automatically detect the file format type.

//For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-C

Aspose::Cells::Startup();
	
//Source directory path
U16String dirPath(u"..\\Data\\LoadingSavingAndConverting\\");

//Create Workbook object from an Excel file path
Workbook  workbook(dirPath + u"sampleExcelFile.xlsx");

//Show following message on console
std::cout << "Workbook opened successfully using file path." << std::endl;

Aspose::Cells::Cleanup();

Opening a File using a Stream

It is also possible to open an Excel file as a stream. To do so, use an overloaded version of the constructor that takes the Stream object that contains the file.

//For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-C

Aspose::Cells::Startup();

//For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-C

  //Source directory path
U16String dirPath(u"..\\Data\\LoadingSavingAndConverting\\");

//You need to write your own code to read the contents of the sampleExcelFile.xlsx file into this variable.
Vector<uint8_t> FileStream{ 0 }; //"sampleExcelFile.xlsx"

//Create Workbook object from a Stream object
Workbook  workbook(FileStream);

//Show following message on console
std::cout << "Workbook opened successfully using stream." << std::endl;

Aspose::Cells::Cleanup();