DataFromFile

  •        69

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.

.NETExcel


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

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


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.


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.

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


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

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.

excellentexport - Javascript export to Excel


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.

PHPMyAdmin


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.

csvtosql


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


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.

Xml To Csv Conversion Tool


This project contains an API that you can use to convert data stored in XML to comma seperated values (csv). There is also a Windows Form client application included. It is programmed in C#4.0.

Excel JDBC Driver


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


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

Excel-like calculating DataTable


Class that make your DataTable calculate formulas capable with runtime totals and user-defined functions

Jasper Reports


JasperReports is the world's most popular open source reporting engine. It is entierly written in Java and it is able to use data coming from any kind of data source and produce pixel-perfect documents that can be viewed, printed or exported in a variety of document formats including HTML, PDF, Excel, OpenOffice and Word.

SDS: Scientific DataSet library and tools


The SDS library makes it easy for .Net developers to read, write and share scalars, vectors, matrices and multidimensional grids which are very common in scientific modelling. It supports CSV, NetCDF and other file format