Open-source Java library to mimic Excel’s “Text Import Wizard”?

Microsoft Excel has a nice “Text Import Wizard” to assist load files that are not.xls or.csv files The user specifies the delimiter utilized (or the repaired width), in addition to some info about column types (general, dates, etc.). Are there any open-source Java libraries that can mimic a similar sort of performance and allow one to put the results into home-brewed information structures?

To clarify, suppose I have an information structure to represent basically a 2D spreadsheet. I want to populate that data structure from a file that may be tab-delimited, comma-delimited, etc (these files may be big BTW). I know there exist a bunch of CSV readers, however are there any that also support the kind of extra markup associated to column types and other types of tailored pre-processing?

I’m not an open-source expert, however I would it to be under a license that wouldn’t require me to release my source code. Thanks.

Yep. OpenCSV lets you select the delimiter, in affect making it able to check out all sort of files.

In Action 3 of the Excel Wizard a user can suggest that columns 1 and 2 are dates, columns 3-5 are text, column 6 is basic, and so on. I was hoping for some similar performance to assist with some preprocessing problems like that.

So I have actually composed a class that makes it very easy to interface with either Excel or Gnumeric utilizing Python, and would like to extend the class to include Google Spreadsheets as well.

The job is open source, and I would reference you at the top of the document if you offer me a hand. If you have actually worked on interfacing with google spreadsheets and you have example code of you doing this, please let me see it!

My project can be found here: https://sourceforge.net/projects/pyworkbooks/ and I motivate you to inspect it out.

You might have a look at the python api of google spreadsheets, This is exactly what you are looking for: http://code.google.com/p/gdata-python-client/.

What I want is to be able to double click on the very first cell in any given row( there’s about 200 jobs) in that Project Summary workbook and that opens that particular project in the currently existing userform that the users are utilizing. I want it to open it at the source file not in the information dump of the Job Summary worksheet.

I will do that for each of the 20 other development report based upon the worth of Variety( E: E). What I want is that when it open the file to pack the userform, it pack the particular report for the worth in A.

If you double-click a cell then it activates (aka runs). If the cell you double-clicked is within the utilized series of the worksheet and in column A then it cancels the ‘in-cell-editing’ and runs the rest of the code. I have actually shown where and ways to load your userform with worths from the row that had column A double-clicked.

Leave a Reply

Your email address will not be published. Required fields are marked *