I have to run few SQL queries and put the results into a spreadsheet. Since I am on a Spring/Java environment, I was about to run the queries using JDBC, iterate through the ResultSet, and use Jakarta POI to create a simple XLS. This looks like a very common requirement, so I was wondering if there is something already available - a pac...
What is the data structure used by spreadsheets program like ms-excel? ...
I've been using Java POI for some time now, but have encountered a new problem, and I'm wondering if anyone has found a solution. When you read a spreadsheet, you need to know the type of cell in order to use the proper read method. So you get the cell type, then call the appropriate read method to get the cell's contents. This works ...
I have an MS-Access application that formats the data in two large spreadsheets (20,000+ rows), imports this data into tables, runs a few queries comparing the data and outputs the results as excel files. The problem is that as the application (and VBA code) grows it's becoming more of a pain using Access and I'm wondering if there is ...
I have heard some genuine arguments for the use of relational database vs spreadsheet before. Relational database provides fast reporting and (relatively speaking) reliable data warehousing,where spreadsheets are lightweight, fast replicating, and easy to float around the organization to different audience. Although I notice the advantag...
Problem: When dealing with web-applications that require grid-based input (but is not a fullblown spreadsheet like Google's) there is a common problem. Either the web-GUI sucks, or it is tied behind some heavily-specialized API that takes way too much training and time to use effectively (not to mention the price tag tends to be high for...
I've never used spreadsheets for anything more than a quick graph. I'd like to learn how to use spreadsheets to their full extent and have been playing around on Google Spreadsheets. There do not seem to be any thorough tutorials on Google Spreadsheets and even Google's documentation often makes references to Excel functionality withou...
I am encountering a strange issue when saving documents in XML Spreadsheet 2003 format using Excel 2007. It seems to randomly change numeric values such as "0.58" to "0.57999999999999996". What's really odd is that you CANNOT see this issue when you are in Excel. You can only see this when viewing the XML data directly from a text edi...
I'm trying to figure out how to create basic functionality of a excel spreadsheet in a web app. Is basic Ajax the best way or is there a good framework for this? ...
Let us say that we have two columns in a spreadsheet. Is it possible to perform set operations on the two columns and save the result in a third column? For eg. Col1 Col2 Col3 --------------------- A B A C D F F C D Here Col3 = Col1 - Col2 where "-" is a set operation. Is there a way to do this in Openoffice Ca...
Duplicate: What is the best third-party WinForms grid for .NET? Hi All, What's your favorite third-party grid or spreadsheet control? I'm working on a c# winforms app that needs a spreadsheet capabilities. Just curious what your experiences/recommendations are... Thanks! ...
How to create and download excel document using asp.net ? The purpose is to use xml, linq or whatever to send an excel document to a customer via a browser. Edit : Use case The customer load a gridview ( made with ajax framework ) in a browser, the gridview is directly linked to an sql database. I put a button 'export to excel' to let...
In my Excel spreadsheet, I've got a cell that is =SUM(C6:C19). If I go to C20 and add a row, that formula will not adjust. I want it to change to =SUM(C6:C20) ...
Hi, I want to develop an iphone interface, using objective-c, which behaves like an Excel sheet. It would display a grid which can be scrolled vertically as well as horizontally but during a vertical scroll, the first row will freeze, and during a horizontal scroll, the first column will freeze. How can this be done? I am new to iphone...
In reference to my previous question, I would like to know how to implement a large grid of cells in an iPhone application. I'm working on an interface which would be similar to an Excel spreadsheet, with many rows and columns. Do I have to handle each cell separately? How can I handle user interaction in each cell? Is there a standard...
I've used the Open XML Format SDK 2.0 to create a simple excel document. Opening the document in Excel first requires Excel to open it. I've narrowed this down to the CellFormats within the Stylesheet. The contents of which are below: <x:styleSheet xmlns:x="http://schemas.openxmlformats.org/spreadsheetml/2006/main"> <x:numFmts coun...
I want a spreadsheet function that will produce a sum of all values in column B for when column A is equal to 'X' and when it is equal to 'Y' A B X 10 Y 3 X 7 X 22 Y 4 Y 9 The output should look like the following (where 39 & 16 are the results of the formulas): X 39 -> 10 + 7 + 22 Y 16 ...
can anyone please tell me how to upload the data from a .csv file on to a webpage which has 4 worksheets with different number of coloums and rows data. ...
Hi, im currently using something like this to insert inline string in a cell : new Cell() { CellReference = "E2", StyleIndex = (UInt32Value)4U, DataType = CellValues.InlineString, InlineString = new InlineString(new Text( "some text")) } But \n doesn't work to insert line break, how can i do this ? Thanks Th...
I'm interested in creating one or more spreadsheet graphs of interval metered data. The raw data is recorded as a continuously increasing value (i.e. total bytes, user logins, website hits) and date. Each sample measurement date will happen at a non-constant interval. For simplicity I would like to record the data in a spreadsheet progra...