Sets the file options used by LEADTOOLS when loading Excel files (XLS or XLSX/XLSB).
#include "ltwrappr.h"
static L_INT LFileSettings::SetExcelOptions(pOptions)
Pointer to a structure that contains the options used when loading Excel files.
Value | Meaning |
---|---|
SUCCESS | The function was successful. |
< 1 | An error occurred. Refer to Return Codes. |
The values set by this function are valid for the current thread. To change the values used by the current thread, this function must be called again.
To get the current options used when loading an Excel file, call LFileSettings::GetExcelOptions.
This function replaces LFileSettings::SetXLSOptions.
Win32, x64.
L_INT TestExcelOptions(LBitmapBase* pLBitmap)
{
L_TCHAR* pszFileName = L_TEXT("1.xlsx");
FILEEXCELOPTIONS options;
L_INT nRet = LFileSettings::GetExcelOptions(&options, sizeof(options));
if (nRet != SUCCESS)
return nRet;
options.uFlags |= EXCEL_FLAGS_SHOWGRIDLINES;
LFileSettings::SetExcelOptions(&options);
LFile file(pLBitmap, pszFileName);
return file.Load(0, ORDER_BGRORGRAY);
}
Help Collections
Raster .NET | C API | C++ Class Library | HTML5 JavaScript
Document .NET | C API | C++ Class Library | HTML5 JavaScript
Medical .NET | C API | C++ Class Library | HTML5 JavaScript
Medical Web Viewer .NET
Multimedia
Direct Show .NET | C API | Filters
Media Foundation .NET | C API | Transforms
Supported Platforms
.NET, Java, Android, and iOS/macOS Assemblies
Imaging, Medical, and Document
C API/C++ Class Libraries
Imaging, Medical, and Document
HTML5 JavaScript Libraries
Imaging, Medical, and Document
Your email has been sent to support! Someone should be in touch! If your matter is urgent please come back into chat.
Chat Hours:
Monday - Friday, 8:30am to 6pm ET
Thank you for your feedback!
Please fill out the form again to start a new chat.
All agents are currently offline.
Chat Hours:
Monday - Friday
8:30AM - 6PM EST
To contact us please fill out this form and we will contact you via email.