SOL9 Sample: XlsToHtmlApplet
|
1 Screenshot
2 Source code
/*
* XlsToHtmlApplet.cpp
* Copyright (c) 2015 Antillia.com TOSHIYUKI ARAI. ALL RIGHTS RESERVED.
*/
// This is a sample program to save an Excel file as an Html file.
#include <sol/office/ExcelApplet.h>
#include <sol/office/ExcelWorkBook.h>
#include <sol/BString.h>
void _tmain(int argc, TCHAR** argv)
{
if (argc !=2) {
printf("Usage: XlsToHtmlApplet.exe XlsFullPathName\n");
return;
}
if (GetFileAttributes(argv[1]) == 0xffffffff) {
_tprintf(_T("File not found %s\n"), argv[1]);
return;
}
try {
BString docname = argv[1];
ExcelApplet applet;
try {
ExcelWorkBook book = applet.open((BSTR)docname, false);
printf("Opend an ExcelFile %S\n", (BSTR)docname);
BString htmlFile = docname + ".html";
_variant_t newfilename = (BSTR)htmlFile;
_variant_t format = (short)Excel:: xlHtml;
book.saveAs(newfilename, format);
printf("Saved As %S\n", (BSTR)htmlFile);
book.close();
printf("Closed a document\n");
} catch (HRESULT hr) {
printf("Exception %x\n", hr);
} catch (...) {
printf("Unknown Exception \n");
}
} catch (HRESULT hr) {
printf("Exception %x\n", hr);
} catch (...) {
printf("Unknown Exception \n");
}
}
Last modified: 2 May 2016
Copyright (c) 2016 Antillia.com ALL RIGHTS RESERVED.