Functions
int	SPI_GEN_read_integer_cell_excel (int line, int row, int *iVal)
	Reads the content of an integer cell on the current sheet.

int	SPI_GEN_read_real_cell_excel (int line, int row, double *rVal)
	Reads the contents of a real cell on the current sheet.

int	SPI_GEN_read_string_cell_excel (int line, int row, std::string &sVal)
	Reads the content of a string cell from the current sheet.

int	SPI_GEN_write_string_cell_excel (int line, int row, const std::string &sVal)
	Writes a string to the current cell.

int	SPI_GEN_write_integer_cell_excel (int line, int row, int iVal)
	Writes an integer to the current cell.

int	SPI_GEN_write_real_cell_excel (int line, int row, double rVal)
	Writes a real to the current cell.

int	SPI_GEN_open_file_excel (const std::string &dir, const std::string &workbook, const std::string &worksheet)
	Opens an Excel workbook and select a current sheet.

int	SPI_GEN_open_file_excel_read_write (const std::string &dir, const std::string &workbook, const std::string &worksheet)
	Opens an Excel workbook and select a current sheet.

int	SPI_GEN_save_file_excel ()
	Saves the current Excel workbook.

void	SPI_GEN_close_file_excel ()
	Closes Excel workbook.

int	SPI_GEN_read_number_cell_excel (int numberRows, int numberColumns)
	Reads the number of rows and columns in an Excel workbook.

Detailed Description

Excel features

Function Documentation

◆ SPI_GEN_close_file_excel()

void SPI_GEN_close_file_excel ( )

Closes Excel workbook.

Version: 4.4

Remarks: Do not forget to save the Excel workbook before if changes have been made; This function just close the current Excel workbook

PCALL(SPI_GEN_close_file_excel);

SPI_GEN_close_file_excel

void SPI_GEN_close_file_excel()

Closes Excel workbook.

Definition sp_gen02.c:421

See also: SPI_GEN_open_file_excel, SPI_GEN_open_file_excel_read_write

◆ SPI_GEN_open_file_excel()

int SPI_GEN_open_file_excel	(	const std::string &	dir,
		const std::string &	workbook,
		const std::string &	worksheet )

Opens an Excel workbook and select a current sheet.

Version: 4.4

Parameters

[in]	dir	Excel workbook directory
[in]	workbook	name of Excel workbook to load
[in]	worksheet	worksheet name to select (empty string => First sheet)

Returns: SPI_YES if Ok | SPI_NO if error (Excel or not file)

Remarks: Automatic closing of the last open Excel workbook; Opens Excel file in read only mode

ier := ICALL(SPI_GEN_open_file_excel,'c:\dir_xl','toto.XLS','');
or
ier := ICALL(SPI_GEN_open_file_excel,'c:\dir_xl','toto.XLS','sheet2');

See also: SPI_GEN_close_file_excel

◆ SPI_GEN_open_file_excel_read_write()

int SPI_GEN_open_file_excel_read_write	(	const std::string &	dir,
		const std::string &	workbook,
		const std::string &	worksheet )

Opens an Excel workbook and select a current sheet.

Version: 6.05.207

Parameters

[in]	dir	Excel workbook directory
[in]	workbook	name of Excel workbook to load
[in]	worksheet	worksheet name to select (empty string => First sheet)

Returns: SPI_YES if Ok | SPI_NO if error (Excel or not file)

Remarks: Automatic closing of the last open Excel workbook; Opens Excel file in read and write mode

ier := ICALL(SPI_GEN_open_file_excel_read_write,'c:\dir_xl','toto.XLS','');
or
ier := ICALL(SPI_GEN_open_file_excel_read_write,'c:\dir_xl','toto.XLS','sheet2');