Showing 17 of total 17 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 21 days ago.
734 stars 20.85 score 160k scripts 815 dependents
sfirke
janitor:Simple Tools for Examining and Cleaning Dirty Data
The main janitor functions can: perfectly format data.frame column names; provide quick counts of variable combinations (i.e., frequency tables and crosstabs); and explore duplicate records. Other janitor functions nicely format the tabulation results. These tabulate-and-report functions approximate popular features of SPSS and Microsoft Excel. This package follows the principles of the "tidyverse" and works well with the pipe function %>%. janitor was built with beginning-to-intermediate R users in mind and is optimized for user-friendliness.
Maintained by Sam Firke. Last updated 3 months ago.
data-analysisdata-cleaningdata-sciencedirty-dataexcelpivot-tablesspsstabulationstidyverse
1.4k stars 19.40 score 35k scripts 231 dependents
gesistsa
rio:A Swiss-Army Knife for Data I/O
Streamlined data import and export by making assumptions that the user is probably willing to make: 'import()' and 'export()' determine the data format from the file extension, reasonable defaults are used for data import and export, web-based import is natively supported (including from SSL/HTTPS), compressed files can be read directly, and fast import packages are used where appropriate. An additional convenience function, 'convert()', provides a simple method for converting between file types.
Maintained by Chung-hong Chan. Last updated 3 months ago.
csvcsvydatadata-scienceexcelioriosasspssstata
610 stars 17.10 score 7.8k scripts 74 dependents
ropensci
writexl:Export Data Frames to Excel 'xlsx' Format
Zero-dependency data frame to xlsx exporter based on 'libxlsxwriter' <https://libxlsxwriter.github.io>. Fast and no Java or Excel required.
Maintained by Jeroen Ooms. Last updated 6 days ago.
212 stars 15.56 score 14k scripts 212 dependents
miraisolutions
XLConnect:Excel Connector for R
Provides comprehensive functionality to read, write and format Excel data.
Maintained by Martin Studer. Last updated 30 days ago.
cross-platformexcelr-languagexlconnectopenjdk
130 stars 12.28 score 1.2k scripts 1 dependents
gdemin
expss:Tables, Labels and Some Useful Functions from Spreadsheets and 'SPSS' Statistics
Package computes and displays tables with support for 'SPSS'-style labels, multiple and nested banners, weights, multiple-response variables and significance testing. There are facilities for nice output of tables in 'knitr', 'Shiny', '*.xlsx' files, R and 'Jupyter' notebooks. Methods for labelled variables add value labels support to base R functions and to some functions from other packages. Additionally, the package brings popular data transformation functions from 'SPSS' Statistics and 'Excel': 'RECODE', 'COUNT', 'COUNTIF', 'VLOOKUP' and etc. These functions are very useful for data processing in marketing research surveys. Package intended to help people to move data processing from 'Excel' and 'SPSS' to R.
Maintained by Gregory Demin. Last updated 12 months ago.
excellabelslabels-supportmsexcelpivot-tablesrecodespssspss-statisticstablesvariable-labelsvlookup
84 stars 11.00 score 1.8k scripts 4 dependents
nacnudus
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
harrison4192
presenter:Present Data with Style
Consists of custom wrapper functions using packages 'openxlsx', 'flextable', and 'officer' to create highly formatted MS office friendly output of your data frames. These viewer friendly outputs are intended to match expectations of professional looking presentations in business and consulting scenarios. The functions are opinionated in the sense that they expect the input data frame to have certain properties in order to take advantage of the automated formatting.
Maintained by Harrison Tietze. Last updated 2 years ago.
11 stars 6.69 score 15 scripts 4 dependents
jhorzek
tablespan:Create Satisficing 'Excel', 'HTML', 'LaTeX', and 'RTF' Tables using a Simple Formula
Create "good enough" tables with a single formula. 'tablespan' tables can be exported to 'Excel', 'HTML', 'LaTeX', and 'RTF' by leveraging the packages 'openxlsx' and 'gt'. See <https://jhorzek.github.io/tablespan/> for an introduction.
Maintained by Jannik H. Orzek. Last updated 2 months ago.
14 stars 5.36 score 30 scripts
bisaloo
xlcutter:Parse Batches of 'xlsx' Files Based on a Template
Parse entire folders of non-rectangular 'xlsx' files into a single rectangular and tidy 'data.frame' based on a custom template file defining the column names of the output.
Maintained by Hugo Gruson. Last updated 1 years ago.
data-extractionexcelnon-rectangular-datatidy-data
7 stars 4.54 score 3 scripts
lgnbhl
xlcharts:Create Native 'Excel' Charts and Work with Microsoft 'Excel' Files
An R interface to the 'OpenPyXL' 'Python' library to create native 'Excel' charts and work with Microsoft 'Excel' files.
Maintained by Felix Luginbuhl. Last updated 23 days ago.
12 stars 4.48 score 4 scripts
kwb-r
kwb.readxl:Read Data From Excel Files
This package is based on the package readxl. It provides functions that read all Excel sheets as pure text and then try to split each sheet into a set of line ranges that are assumed to represent single tables.
Maintained by Hauke Sonnenberg. Last updated 5 years ago.
data-importexcelproject-fakinproject-geosalzspreadsheets
3.48 score 1 scripts 1 dependents
framverse
xldiff:Compare excel sheets
`xldiff` provides tools to compare excel sheets, broadly inspired by "diff"-type functions. Provided functions can read sheets of two excel files and produce a third file that highlights cells that have changed. In the case of numeric changes, the direction of change is highlighted. These tools do not account for structural changes in the sheets (e.g., the addition of a column), but are useful in tracking changed values in tables or parameter files. Utility functions developed to streamline formatting output files are also more broadly useful in programmatically formatting excel files using openxlsx.
Maintained by Collin Edwards. Last updated 14 days ago.
3.02 score 1 dependentskwb-r
kwb.lca:Functions to Be Used in Life Cycle Assessment (LCA) Projects
This package contains a function to read LCA. parameters from an Excel file that was sent to and received from a project partner. The parameters are read into a data frame. Another function can be used to write the dataframe into an Excel file with different sheets and data.
Maintained by Hauke Sonnenberg. Last updated 5 years ago.
data-aggregationdata-exportdata-importdata-visualisationexcellife-cycle-assessmentmodellingproject-fakinproject-smartplantquestionairesspreadsheetstemplate
2 stars 3.00 score 1 scriptskwb-r
kwb.geosalz:R Package for Documenting Workflow Used in Project "geosalz"
R Package for Documenting Workflow Used in Project "geosalz".
Maintained by Michael Rustler. Last updated 1 years ago.
data-cleaningdata-importdata-visualisationexcelproject-fakinproject-geosalzspreadsheets
2.00 score 3 scripts