Projects tagged ‘excel’ and ‘export’

Generating Excel 97+ files with Python 2.4+ (need decorators), importing Excel 95+ files, support for UNICODE in Excel files, using variety of formatting features and printing options, Excel files and ... [More] OLE2 compound files dumper. No need in Windows/COM. [Less]

Hello Folks, Raise your hands if you enjoy the power of "Zero Code" ? That's everyone. Thanks to ASP.NET 2.0. Most of the heavy lifting is done by the framework. I would like to present to you a ... [More] new custom control that I developed. This control "Exports" the contents of your "GridView" into Excel format with "Zero Code". That's right. Simply drag and drop and you are all set. Note: Copyright (c) Rajesh Krishnamohan. All rights reserved. This software is provided "AS IS", without any express or implied warranty. In no event will the authors be held liable for any damages arising from the use of this software. [Less]

BeanFiles is a java library for importing and exporting javabeans to/from various file formats. Right now, it only supports importing from csv using opencsv and xls using POI. Check out the ... [More] examples. Beanfiles aims to facilitate type conversion and multiple input/output formats while reusing some of the underlying translation components. The library currently supports importing only, but has some useful features. It supports the following: No configuration (if column headers match bean property names) Property Mapping (if column headers do not match bean property names) Nested property resolutions (bean.childBean.property.whatever) Simple wildcard mappings (image* will build a list of strings where column header is imageXyz) Easily add custom translators (for instance a column is an id, and the bean property is a lookup) A nice use-case is creating beans with the beanfiles library, then using Hibernate to store objects to a relational model. There's a Google group for discussing this project: http://groups.google.com/group/beanfiles Example UsageConsider the following csv file: property1,property2,property3,property4,property5 line1_prop1,line1_prop2,line1_prop3,1,FALSE line2_prop1,line2_prop2,line2_prop3,2,TRUEIn order to map this data to the following Java Bean: public class SimpleBean { private String property1; private String property2; private String property3; private int property4; private boolean property5; public SimpleBean() {} public String getProperty1() { return property1; } public void setProperty1(String property1) { this.property1 = property1; } ... } Here's the Beanfiles code: InputStream input = getInputStream("files/csv/simple_properties.csv"); ReaderIterator iterator = new CSVReaderIterator(SimpleBean.class, input); input.close(); SimpleBean bean1 = iterator.next(); SimpleBean bean2 = iterator.next(); [Less]

Microsoft SQL Data Services(SDS) give us large flexibility and scalability in data hosting and handling,but different from ordinary RDBMS, consisted not in Table and Fields, but in Authority and ... [More] Entity. This toolkit helps developer or DBA to migrate existing data to SDS. [Less]

This tooltask is an alternative to the initial Apache/Ant script used to call the vbaMaven, and a good start in migrating vbaMaven to dotnet..

Tool for export sql query resultsets from Oracle databases into binary Excel files and import table data from binary Excel files into Oracle tables.

Tutorial requires 1 PHP file and 1 table of mySQL database. export_excel.php 2. Database "tutorial" and table "name_list" with 2 fields: id(auto_increment), name(varchar, 50) and put some records ... [More] about 20 - 30 records into this table. (directly by phpMyAdmin) [Less]

XMLSpreadGear helps to generate Excel files using the collection of an object. Concept of transforming is based on the open excel specification. Using this utility one can export data from a ... [More] collection directly to excel file. Any project based on .net technology can use this. [Less]

A lightweight, simple and fast PHP Class which exports array data to Excel's .XLS format. The array data could come from MySQL or any other data source, but as long as its in the normal PHP array ... [More] format, then this script will produce a simple xls out of it. [Less]