DataFromFile

  •        74

DataFromFile is a small class (written in C#) which makes it easy to deal with data files such as Excel (xls or xlsx) or CSV.

http://datafromfile.codeplex.com/

Tags
Implementation
License
Platform

   




Related Projects

Run SELECT, INSERT, UPDATE, DELETE statements against DataSet and DataTable.

  •    

QueryAnything allows user to run SQL statements against any data files that can be read into DataSet and DataTable objects. Currently support XML and CSV files. And more to come...

Corrupt XLSX Salvager

  •    

Recover Data for Excel XLSX Files Excel Won't Open

Data Export

  •    

DataExporter is a module for DotNetNuke. It allows to export Data from the DotNetNuke database. Module supports Excel, XML and CSV formats for export. Users interface allows to select source of Data: Tables, Views or Custom Query. It simple, easy and fast tool for DNN Admins.

php-export-data - PHP class to export data in CSV, TSV, or Excel XML (aka SpreadsheeML) format to a file or directly to the browser

  •    PHP

A simple library for exporting tabular data to Excel-friendly XML, CSV, or TSV. It supports streaming exported data to a file or directly to the browser as a download so it is suitable for exporting large datasets (you won't run out of memory). See the test/ directory for more examples.

readr - Read flat files (csv, tsv, fwf) into R

  •    R

The goal of readr is to provide a fast and friendly way to read rectangular data (like csv, tsv, and fwf). It is designed to flexibly parse many types of data found in the wild, while still cleanly failing when data unexpectedly changes. If you are new to readr, the best place to start is the data import chapter in R for data science. To accurately read a rectangular dataset with readr you combine two pieces: a function that parses the overall file, and a column specification. The column specification describes how each column should be converted from a character vector to the most appropriate data type, and in most cases it's not necessary because readr will guess it for you automatically.


.NETExcel

  •    

OLE DB-based Library written in C# for reading, & writing MS Excel files (97-2010).

ExcelExportLib

  •    

ExcelExportLib is a simple data export library wich creates an .xml file. This file can be opened in Excel. Unlike .csv files this format contains formatting information. Main goal of project is to export data in excel format without running Excel.

ISO-3166-Countries-with-Regional-Codes - ISO 3166-1 country lists merged with their UN Geoscheme regional codes in ready-to-use JSON, XML, CSV data sets

  •    Ruby

These lists are the result of merging data from two sources, the Wikipedia ISO 3166-1 article for alpha and numeric country codes, and the UN Statistics site for countries' regional, and sub-regional codes. In addition to countries, it includes dependent territories. The International Organization for Standardization (ISO) site provides partial data (capitalised and sometimes stripped of non-latin ornamentation), but sells the complete data set as a Microsoft Access 2003 database. Other sites give you the numeric and character codes, but there appeared to be no sites that included the associated UN-maintained regional codes in their data sets. I scraped data from the above two websites that is all publicly available already to produce some ready-to-use complete data sets that will hopefully save someone some time who had similar needs.

dataset - Easy-to-use data handling for SQL data stores with support for CSV and JSON data export

  •    Python

Easy-to-use data handling for SQL data stores with support for CSV and JSON data export

excellentexport - Javascript export to Excel

  •    Javascript

A quick JavaScript library to create export to Excel/CSV from HTML tables in the browser. No server required. As part of the new version 3.0.0+, there is support for XLSX. The drawback is that the library is 600+ KB.

echo - Echo converts HTML tables into JSON/CSV objects. Use it to make html data easy to transport.

  •    Javascript

Echo is able to read tables from a website or a html file and convert it to JSON or CSV. Perfect for saving data from a website and loading it into excel, database, etc. For our examples we will be using the tables from www.coolgithubprojects.com. We use .convert for local HTML files and .convertUrl for online retrieval.

PHPMyAdmin

  •    PHP

phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.

Runtime DataSet/DataTable viewer

  •    

This component basically allows you to inspect the contents of any Data Set or a Data Table at runtime without breaking into the debugger again and again.

Laravel-Excel - 🚀 Supercharged Excel exports in Laravel

  •    PHP

Supercharged Excel exports A simple, but elegant wrapper around PhpSpreadsheet with the goal of simplifying exports. Easily export collections to Excel. Supercharge your Laravel collections and export them directly to an Excel or CSV document. Exporting has never been so easy.

csvtosql

  •    Java

Csvtosql is a library and tool to convert any CSV-based data. It accepts multiple data formats (such as CSV, Excel, or arrays), converts it into SQL statements, and writes the data back in multiple formats (textfile, database).

django-rest-pandas - 📊📈 Serves up Pandas dataframes via the Django REST Framework for use in client-side (i

  •    Python

Django REST Pandas (DRP) provides a simple way to generate and serve pandas DataFrames via the Django REST Framework. The resulting API can serve up CSV (and a number of other formats) for consumption by a client-side visualization tool like d3.js. The design philosophy of DRP enforces a strict separation between data and presentation. This keeps the implementation simple, but also has the nice side effect of making it trivial to provide the source data for your visualizations. This capability can often be leveraged by sending users to the same URL that your visualization code uses internally to load the data.

palladium - Framework for setting up predictive analytics services

  •    Python

Palladium provides means to easily set up predictive analytics services as web services. It is a pluggable framework for developing real-world machine learning solutions. It provides generic implementations for things commonly needed in machine learning, such as dataset loading, model training with parameter search, a web service, and persistence capabilities, allowing you to concentrate on the core task of developing an accurate machine learning model. Having a well-tested core framework that is used for a number of different services can lead to a reduction of costs during development and maintenance due to harmonization of different services being based on the same code base and identical processes. Palladium has a web service overhead of a few milliseconds only, making it possible to set up services with low response times. A configuration file lets you conveniently tie together existing components with components that you developed. As an example, if what you want to do is to develop a model where you load a dataset from a CSV file or an SQL database, and train an SVM classifier to predict one of the rows in the data given the others, and then find out about your model's accuracy, then that's what Palladium allows you to do without writing a single line of code. However, it is also possible to independently integrate own solutions.

Excel JDBC Driver

  •    Java

xlSQL JDBC Driver for Excel, CSV and XML files. xlSQL maps a directory of Excel files to a database, workbooks to schemas and sheets to tables. Query documents with either the full HSQL or MySQL dialect. Write objects and data with native xlSQL.

xlsLib

  •    Objective-C

C++/C library to construct Excel .xls files in code.