I'm trying to calculate the conditional median of a chart that looks like this: A | B ------- x | 1 x | 1 x | 3 x | y | 4 z | 5 I'm using MS Excel 2007. I am aware of the AVERAGEIF() statement, but there is no equivalent for Median. The main trick is that there are rows with no data - such as the 4th "a" above. In th...
Many web applications today have spreadsheets. I was trying to make a very similar table, but with reduced funcionality: editable cells pressing the arrow keys, or would make you go to a cell next to the current one (in the proper direction) I found ext grid and YUI DataTable, and besides they being editable I haven't found ...
Hi, all. I'm trying to accomplish something in Excel that I'm pretty sure requires some VB work, which I've never actually done, before. I've got a spreadsheet with two columns that represent the number of processed records, and the date the records were processed. In some cases, the records can be processed in multiple batches, so th...
I want to count the no. of pages that would be produced if I printed out an OpenOffice.org document. I can already do it for ODT files using the following code: public short getPageCount() { XModel model = (XModel) UnoRuntime.queryInterface(XModel.class, getDocument()); XTextViewCursorSupplier s...
[cross posted again to Mahalo answers] My Perl/Tk script has an initial spreadsheet like grid displayed using the Tk::TableMatrix::Spreadsheet modules. My spreadsheet is programatically called $ss. This initial grid is wiped before the display of the first spreadsheet, with $ss->pack('forget'); The script as it is now also adds $mw-...
I'm just beginning to dive into VBA and I've hit a bit of a roadblock. I have a sheet with 50+ columns, 900+ rows of data. I need to reformat about 10 of those columns and stick them in a new workbook. How do I programmatically select every non-blank cell in a column of book1, run it through some functions, and drop the results in book...
Is there a good way to get the first empty cell in a column from Google's spreadsheet service via Java? I know I can use: public CellFeed CheckColumn(int row, int col) throws IOException, ServiceException { CellQuery query = new CellQuery(cellFeedUrl); query.setMinimumRow(row); query.setMaximumRow(row); query.setMi...
Hi! I have one huge spreadsheet file (1000+ lines) and one postgreSQL table. I need to compare spreadsheet data with postgresql table data and add fill the blank fields in table with data from spreadsheet and add entries not present in db table. Yes, I can convert (via csv) whole spreadsheet into database table. But, there are unique v...
I would like to be able to automate creating spreadsheets and adding data to an OpenOffice spreadsheet using a script (any scripting language is acceptable - PowerShell, Python, or even JavaScript). What is a suitable library or tutorial? ...
I want to store the spreadsheet data in database, so right now i am using key/value pattern to store the same but its taking too much time to retrieve it from data base, if the data is huge. Do anyone has the best way to do the same. How Google saves their spreadsheet data? Usually I have to show 30 to 40 columns and 10,000 rows on the...
I have had this recurring problem with all of my spreadsheets for months. The spreadsheet will be working fine and importing the xml files fetched from our website, then all of a sudden it will start crashing everytime on import. The only thing that fixes it is to take all of the contents (sheets, code, references) and drop them into a...
My form looks like this with a DataGridView: http://sites.google.com/site/shadchanproject/Home/Untitled.jpg?attredirects=0 I would like to make it look more professional. Can someone recommend a "makeover" for it? Perhaps there is a more attractive way to display this data. ...
I'm using a simple web-based PHP application that outputs a table as a spreadsheet header("Content-Disposition: attachment; filename=" . $filename . ".xls"); header("Content-Type: application/vnd.ms-excel"); //inserts tab delimited text But I'm finding the downloaded spreadsheet opens as a read-only file and must be saved locally and...
I know it is easy to display a counter on a webpage but I need to implement the same, ie, I need to write data to a cell in the Excel 2007 spreadsheet every time a person downloads it from my webpage. To be more precise, when the user downloads the excel file to his hard drive and when it is opened, I want the spreadsheet to display the ...
Every time I am laying out documents for some project, I like to refer to a tree of components/subcomponents/subsubcomponents... I found apps like treepad or keynote, which help outline documents in trees, but the leaves of the tree are always rich text, so it's hard to do math or filters on their content. What I'm looking for is some ...
Hi i working a fairly large spreadsheet which is broken down into months. I want to put the yearly subtotals at the begining of the spreadsheet. So in cell A1 i want to add AA2-AL2, B1 i want to add AM2-AX2 and so on so forth. How can i do this whithout manually going to each set of values. Is there anyway i can put a formula in A1 whi...
Using Javascript, how do I create an HTML table that can "accept" numeric matrix data from excel (or google spreadsheet), via "copy" in the spreadsheet and then "paste" into the table in the browser. Thanks. ...
How to rotate text which is there in HSSFCell class of Apache POI API? Can you please provide some example code for the same? ...
Hi, How to add Image in different different HSSFCell object in poi ? I have written some code which is adding image but problem is, the cell were I added last image, That cell only showing image other than that no other cells are showing images ... appreciate your help ... My Code is while(rs.next()){ HSSFCell cell = getHSSFCell(s...
Hey guys I have a question about a method to break something apart. I get this excel spreadsheet that provides me with data that I need to do one report. Its pretty simple and straight forward, however there is one particular part of it that is giving me some grief. In the excel spreadsheet there is a column that lists "parties envolved...