ExcelDataReader
googlesheets4
| ExcelDataReader | googlesheets4 | |
|---|---|---|
| 11 | 4 | |
| 3,797 | 352 | |
| - | 0.9% | |
| 6.4 | 4.7 | |
| 18 days ago | 3 days ago | |
| C# | R | |
| MIT License | GNU General Public License v3.0 or later |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
ExcelDataReader
- Use spreadsheet as data source?
- Creating a Web App using Excel
-
C# Excel Interop quit and releasecomobjects after the user closed excel
https://github.com/ExcelDataReader/ExcelDataReader works with all versions
-
What's the best way to read an Excel file into a DataGrid in WinUi 3?
ExcelDataReader is the way forward. I dont know what you mean when you say??
- Easiest Way to Read and Import Excel File Data into DataTable C#
- Dot net libraries/tools that are usefull in many projects
-
Read Excel file in .NET 6 deployed on Linux?
Have you tried https://github.com/ExcelDataReader/ExcelDataReader ?
- Coming from Python and wondering if I should use Pandas.NET or learn built-in Dataframe stuff
-
.NET MiniExcel simple and efficient Excel tool to avoid OOM(out of memory).
ExcelDataReader
- How should I go about reading excel data and converting it to JSON in C#?
googlesheets4
-
Use spreadsheet as data source?
I have used google sheets as a data source before. One can feed it with google forms (to populate rows) and it can handle concurrent users entering stuff. Never did ~1000 though— that’s a lot. There is a tidyverse package, googlesheets4, that reads the sheets. It works fine. There are similar packages for excel.
-
Beginner needing help splitting a table into 2 tables based on mean value
Here is a guide to reading Google Sheets data into R.
-
R Shiny Input UI
If you can do it programatically, you can do it with Shiny (its just the interface). Here is an api for working with Google sheets (https://googlesheets4.tidyverse.org/).
- Need help converting google sheet to pandas dataframe, without google API or public viewing setting.
What are some alternatives?
EPPlus
dplyr - dplyr: A grammar of data manipulation
NPOI - a .NET library that can read/write Office formats without Microsoft Office installed. No COM+, no interop.
unpivotr - Unpivot complex and irregular data layouts in R
ClosedXML - ClosedXML is a .NET library for reading, manipulating and writing Excel 2007+ (.xlsx, .xlsm) files. It aims to provide an intuitive and user-friendly interface to dealing with the underlying OpenXML API.
ShinyWebAppWithFormAndLeafletMap - This repo contains the code to build a webapp for data collection and viewing the map on a leaflet map using R Shiny. The specific webapp that I built is aimed to collect data of sustainability practices of various eateries around the world, in the times of climate change.
Open XML SDK - Open XML SDK by Microsoft
Sylvan.Data.Excel - The fastest .NET library for reading Excel data files.
MiniExcel - Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet (support Linux, Mac)
Report-From-DocX-HTML-To-PDF-Converter - .NET Core library to create custom reports based on Word docx or HTML documents and convert to PDF
ExcelMapper - An Excel to object mapper. Maps POCOs to and from Excel. Configuration via convention, attributes, or fluent methods.
FileHelpers - The FileHelpers are a free and easy to use .NET library to read/write data from fixed length or delimited records in files, strings or streams