/*
 * Copyright (c) 2000-2011 TeamDev Ltd. All rights reserved.
 * Use is subject to license terms.
 */
import com.jniwrapper.win32.jexcel.*;
import java.io.File;

public class WorkbookSaveSample
{
    public static void main(String[] args) throws Exception {

        Application application = new Application();
        //Creating file in the working directory
        File xlsFile = new File("testing_result.xlsx"); 
        Workbook workbook = application.createWorkbook("sample");
        Worksheet worksheet = workbook.getWorksheet(1);

        //Set numerical values to cells
        Cell cell = worksheet.getCell("C4");
        cell.setValue(200);
        //Cell object needs to be explicitly released
        cell.release();

        cell = worksheet.getCell("D4");
        cell.setValue(100);
        cell.release();

        cell = worksheet.getCell("E4");
        cell.setValue(50);
        cell.release();

        //Set a formula value to the cell
        cell = worksheet.getCell("A1");
        cell.setValue("=C4-D4-E4");
        cell.release();

        //OPENXMLWORKBOOK corresponds to regular 2007 *.xlsx workbook
        workbook.saveAs(xlsFile, FileFormat.OPENXMLWORKBOOK,true);
        workbook.close(false);
        application.close();
    }
}