hide_sheet.bas

/'
 * Example of how to hide a worksheet using libxlsxwriter.
 *
 * Copyright 2014-2017, John McNamara, jmcnamara@cpan.org
 *
 * translated by Lee June by using https://github.com/retsyo/libxlsxwriter_freebasic
 '/

#include "auto_xlsxwriter.bi"

function main() as Integer

    var workbook   = workbook_new("hide_sheet.xlsx")
    var worksheet1 = workbook_add_worksheet(workbook, NULL)
    var worksheet2 = workbook_add_worksheet(workbook, NULL)
    var worksheet3 = workbook_add_worksheet(workbook, NULL)

    /' Hide Sheet2. It won't be visible until it is unhidden in Excel. '/
    worksheet_hide(worksheet2)

    worksheet_write_string(worksheet1, 0, 0, "Sheet2 is hidden", NULL)
    worksheet_write_string(worksheet2, 0, 0, "Now it's my turn to find you!", NULL)
    worksheet_write_string(worksheet3, 0, 0, "Sheet2 is hidden", NULL)

    /' Make the first column wider to make the text clearer. '/
    worksheet_set_column(worksheet1, 0, 0, 30, NULL)
    worksheet_set_column(worksheet2, 0, 0, 30, NULL)
    worksheet_set_column(worksheet3, 0, 0, 30, NULL)

    workbook_close(workbook)

    return 0
End Function

main()