SOL9 2.0 Samples

1 Screenshot

2 Source code

/*
 * ExcelApplet.cpp 
 * Copyright (c) 2015 Antillia.com TOSHIYUKI ARAI. ALL RIGHTS RESERVED. 
 */


// This is a sample program to open and close an Excel file by using SOL::ExcelApplet class.

#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: ExcelApplet.exe ExcelFileFullPath\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, true);
      printf("Opened a workbook %S\n", (BSTR)docname);
    
      book.close();
      printf("Closed a workbook\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");
  }
}