1C:Enterprise | 1C:Enterprise Developer's Community

SpreadsheetDocument.Read

Syntax:

Read(<FileName>, <ValuesReadingMode>)

Parameters:

<FileName> (required)

Type: String.
Spreadsheet document file name.

<ValuesReadingMode> (optional)

Type: SpreadsheetDocumentValuesReadingMode.
Defines how to interpret the values read from the source document in XLS, XLSX, or ODS format.
If an Excel 97 - 2010 or OpenOffice Calc spreadsheet document is downloaded and a source document cell contains a value of type Date or Number, this value is inserted into the resulting spreadsheet document cell depending on the value of that parameter.
Default value: Text.

Description:

It reads spreadsheet document from the file.
It allows reading the spreadsheet document from the file in Microsoft Excel 97 - 2010 ( *.xls and *.xlsx) or a digital table OpenOffice Calc ( *.ods).

Availability:

Server, thick client, external connection, Mobile application (server).

Example:

Spreadsheet = New SpreadsheetDocument;
Spreadsheet.Read("C:\My Documents\Table1.mxl");