Files in openxlsx

Read, Write and Edit xlsx Files

NEWS.md README.md R/RcppExports.R R/WorkbookClass.R R/setWindowSize.R R/sheet_data_class.R R/workbook_write_data.R R/openXL.R R/baseXML.R R/writeDataTable.R R/writexlsx.R R/data-fontSizeLookupTables.R R/readWorkbook.R R/CommentClass.R R/workbook_read_workbook.R R/wrappers.R R/borderFunctions.R R/conditional_formatting.R R/HyperlinkClass.R R/helperFunctions.R R/asserts.R R/openxlsxCoerce.R R/onUnload.R R/loadWorkbook.R R/openxlsx-package.R R/class_definitions.R R/build_workbook.R R/zzz.R R/openxlsx.R R/StyleClass.R R/workbook_column_widths.R R/worksheet_class.R R/writeData.R R/chartsheet_class.R R/utils.R inst/doc/Formatting.R inst/doc/Introduction.R inst/doc/Introduction.Rmd inst/doc/Formatting.Rmd inst/extdata/conditional_formatting_testing.R inst/extdata/stack_style_testing.R inst/extdata/load_xlsx_testing.R inst/extdata/build_font_size_lookup.R tests/testthat.R tests/testthat/test-grouped_rows.R tests/testthat/test-styles.R tests/testthat/test-validate_data.R tests/testthat/test-deleting_tables.R tests/testthat/test-fill_merged_cells.R tests/testthat/test-loading_workbook.R tests/testthat/test-load_read_file_read_equality.R tests/testthat/test-worksheet_ordering.R tests/testthat/test-fontSizeLookupTables.R tests/testthat/test-build_workbook.R tests/testthat/test-date_time_conversion.R tests/testthat/test-skip_empty_rows.R tests/testthat/test-cloneWorksheet.R tests/testthat/test-protect-workbook.R tests/testthat/test-wrappers.R tests/testthat/test-trying_to_break_openxlsx.R tests/testthat/test-write_data_to_sheetData.R tests/testthat/test-read_from_created_wb.R tests/testthat/test-CommentClass.R tests/testthat/test-activeSheet.R tests/testthat/test-write_xlsx_vector_args.R tests/testthat/test-skip_empty_cols.R tests/testthat/test-write-permissions.R tests/testthat/test-setWindowSize.R tests/testthat/test-worksheet_renaming.R tests/testthat/test-loading_workbook_unzipped.R tests/testthat/test-conditionalFormatting.R tests/testthat/test-setColWidths.R tests/testthat/test-read_from_loaded_workbook.R tests/testthat/test-read_write_logicals.R tests/testthat/test-read_xlsx_correct_sheet.R tests/testthat/test-getBaseFont.R tests/testthat/test-write_read_equality.R tests/testthat/test-saveWorkbook.R tests/testthat/test-page_setup.R tests/testthat/test-options.R tests/testthat/test-write_data_to_sheetData_NAs.R tests/testthat/test-loading_workbook_tables.R tests/testthat/test-border_parsing.R tests/testthat/test-named_regions.R tests/testthat/test-protect-worksheet.R tests/testthat/test-v3_0_0_bugs.R tests/testthat/test-Worksheet_naming.R tests/testthat/test-outlines.R tests/testthat/test-freeze_pane.R tests/testthat/test-encoding.R tests/testthat/test-writeData.R tests/testthat/test-read_xlsx_random_seed.R tests/testthat/test-validate_table_name.R tests/testthat/test-writeDataTable.R tests/testthat/test-writing_sheet_data.R tests/testthat/test-Workbook_properties.R tests/testthat/test-insertImage.R tests/testthat/test-table_overlaps.R tests/testthat/test-remove_worksheets.R tests/testthat/test-writing_posixct.R tests/testthat/test-read_sources.R tests/testthat/test-getCellRefs.R vignettes/Introduction.Rmd vignettes/Formatting.Rmd man/writeDataTable.Rd man/activeSheet.Rd man/removeCellMerge.Rd man/worksheetOrder.Rd man/removeWorksheet.Rd man/copyWorkbook.Rd man/openxlsx_options.Rd man/if_null_then.Rd man/createStyle.Rd man/convertToDate.Rd man/getBaseFont.Rd man/groupRows.Rd man/mergeCells.Rd man/openxlsx.Rd man/groupColumns.Rd man/showGridLines.Rd man/as.character.formula.Rd man/modifyBaseFont.Rd man/readWorkbook.Rd man/writeData.Rd man/setWindowSize.Rd man/removeComment.Rd man/getStyles.Rd man/write.xlsx.Rd man/sheets.Rd man/ungroupRows.Rd man/saveWorkbook.Rd man/getCellRefs.Rd man/NamedRegion.Rd man/renameWorksheet.Rd man/removeTable.Rd man/col2int.Rd man/sheetVisible.Rd man/writeComment.Rd man/setColWidths.Rd man/dataValidation.Rd man/addStyle.Rd man/openXL.Rd man/createWorkbook.Rd man/insertPlot.Rd man/createComment.Rd man/getSheetNames.Rd man/loadWorkbook.Rd man/as_POSIXct_utc.Rd man/convertToDateTime.Rd man/openxlsxFontSizeLookupTable.Rd man/insertImage.Rd man/cloneWorksheet.Rd man/setFooter.Rd man/removeColWidths.Rd man/setHeader.Rd man/writeFormula.Rd man/protectWorkbook.Rd man/all.equal.Rd man/buildWorkbook.Rd man/ungroupColumns.Rd man/getTables.Rd man/auto_heights.Rd man/sheetVisibility.Rd man/names.Rd man/protectWorksheet.Rd man/getNamedRegions.Rd man/removeRowHeights.Rd man/getCreators.Rd man/addCreator.Rd man/getDateOrigin.Rd man/deleteData.Rd man/makeHyperlinkString.Rd man/get_worksheet_entries.Rd man/read.xlsx.Rd man/setRowHeights.Rd man/conditionalFormat.Rd man/pageBreak.Rd man/addFilter.Rd man/conditionalFormatting.Rd man/addWorksheet.Rd man/freezePane.Rd man/convertFromExcelRef.Rd man/setHeaderFooter.Rd man/pageSetup.Rd man/removeFilter.Rd man/setLastModifiedBy.Rd man/replaceStyle.Rd man/temp_xlsx.Rd man/deleteDataColumn.Rd man/int2col.Rd man/figures/tableoptions.pdf