Showing 7 of total 7 results (show query)
tidyverse
readxl:Read Excel Files
Import excel files into R. Supports '.xls' via the embedded 'libxls' C library <https://github.com/libxls/libxls> and '.xlsx' via the embedded 'RapidXML' C++ library <https://rapidxml.sourceforge.net/>. Works on Windows, Mac and Linux without external dependencies.
Maintained by Jennifer Bryan. Last updated 22 days ago.
734 stars 20.85 score 160k scripts 815 dependentstidyverse
googlesheets4:Access Google Sheets using the Sheets API V4
Interact with Google Sheets through the Sheets API v4 <https://developers.google.com/sheets/api>. "API" is an acronym for "application programming interface"; the Sheets API allows users to interact with Google Sheets programmatically, instead of via a web browser. The "v4" refers to the fact that the Sheets API is currently at version 4. This package can read and write both the metadata and the cell data in a Sheet.
Maintained by Jennifer Bryan. Last updated 8 months ago.
google-drivegoogle-sheetsspreadsheet
363 stars 14.55 score 7.0k scripts 144 dependents
nacnudus
tidyxl:Read Untidy Excel Files
Imports non-tabular from Excel files into R. Exposes cell content, position and formatting in a tidy structure for further manipulation. Tokenizes Excel formulas. Supports '.xlsx' and '.xlsm' via the embedded 'RapidXML' C++ library <https://rapidxml.sourceforge.net>. Does not support '.xlsb' or '.xls'.
Maintained by Duncan Garmonsway. Last updated 1 years ago.
excelreaderrcppspreadsheettidycpp
251 stars 10.76 score 382 scripts 14 dependentsnacnudus
unpivotr:Unpivot Complex and Irregular Data Layouts
Tools for converting data from complex or irregular layouts to a columnar structure. For example, tables with multilevel column or row headers, or spreadsheets. Header and data cells are selected by their contents and position, as well as formatting and comments where available, and are associated with one other by their proximity in given directions. Functions for data frames and HTML tables are provided.
Maintained by Duncan Garmonsway. Last updated 2 months ago.
186 stars 10.35 score 368 scripts 3 dependents
best-practice-and-impact
aftables:Create Spreadsheet Publications Following Best Practice
Generate spreadsheet publications that follow best practice guidance from the UK government's Analysis Function, available at <https://analysisfunction.civilservice.gov.uk/policy-store/releasing-statistics-in-spreadsheets/>, with a focus on accessibility. See also the 'Python' package 'gptables'.
Maintained by Olivia Box Power. Last updated 1 months ago.
accessibilityopenxlsxreproducible-analytical-pipelinespreadsheetuk-gov-data-science
48 stars 6.76 score 4 scripts
eoda-dev
rtabulator:R Bindings for 'Tabulator JS'
Provides R bindings for 'Tabulator JS' <https://tabulator.info/>. Makes it a breeze to create highly customizable interactive tables in 'rmarkdown' documents and 'shiny' applications. It includes filtering, grouping, editing, input validation, history recording, column formatters, packaged themes and more.
Maintained by Stefan Kuethe. Last updated 5 months ago.
bindingshtmlwidgetsrlangshinyspreadsheettabletabulator-js
11 stars 4.44 score 9 scripts
mattkerlogue
tidyods:Read cells from ODS files
Import cells from ODS files. Identify a cell's postion, value types and formulas, and provide methods to "rectify" cells back to a 2-dimensional data.frame.
Maintained by Matt Kerlogue. Last updated 2 years ago.
odsods-filesopendocumentopendocument-spreadsheetspreadsheettidytidy-data
4 stars 3.30 score 5 scripts