Several people have asked how to export data to Excel. This code snippet shows how to export the data from a listview in details mode to a new Excel spreadsheet. Take note of the comments in the header to avoid having orphaned Excel.exe tasks eat up your system memory.

Member Avatar
Member Avatar
+7 forum 15

Hi I thought this was easy. I want to copy a spreadsheet in a workbook to a new spreadsheet in the same workbook preserving links. So as the source worksheet received new entries the copied spreadsheet would be updated. My reason being that I would introduce some variation in the way that data was computed on a few lines.

Member Avatar
Member Avatar
+0 forum 3

Hello I am using jxls quite fine. I'm sort of on my last lap with exporting my data to a file. However all I want to know is, how do I display my collection in the same row please? I've manage to do this downwards in the same column, but I'm not sure how to display them across in the same row. There website telss me how to do multiple collections across, but not one. Oy. I hope someone has an idea, because it "seems" simple enough.....seeems, but I judt don't tknow the syntax.

Member Avatar
Member Avatar
+0 forum 1

I'm wondering if anyone has any experiencing getting a python application to authenticate with google docs. I'm not sure how to begin. Goal: To update a google docs spreadsheet based of a CSV file on my local machine. Currently my google account is set for two factor authentication. Perhaps this might be a issue with what I'm trying to do. I''m not sure. I know there is oAuth2 but Im ocmopletely lost on how to implement it. I have looked at the google API and needless to say I'm confused. Any help would be greatly apprciated.

Member Avatar
Member Avatar
+0 forum 1

Hi, I need to create a page where an admin can upload an excel worksheet in the .xlsx file format, this is then read and writen onto another php page. I'm new to PHP so I am confused by the code, I can find help on .xls but not accepting .xlsx. Thanks for any help.

Member Avatar
Member Avatar
+0 forum 1

Machine running Windows 7 Pro 64 bit. MS Office 2010. Problem is once there is a spreadsheet open and minimized and you click on a second spreadsheet shortcut, it won't open. You will get the blue circle so it is trying. You can do it through file/resent files and open it that way. The shortcut is a file that lives on a server. Other identical machines are set up and have shortcuts to the same files. This is the only one that does that.

Member Avatar
Member Avatar
+0 forum 2

I have a page in which users are an employee of a charity. They can / should enter information about their organization including phone numbers. It occurs to me that some organizations may have dozens or even hundreds of phone numbers. I do NOT want to have to place that many `<input>` tags on the page since most users will never need them. I thought it would be nice if there were some sort of input device that can be expanded as needed like a spreadsheet. If there is no such control, I want one. I want it very similar …

Member Avatar
Member Avatar
+0 forum 1

I'd like to create something like this: http://www.million-monkeys.com/tvcyo/ I'd love to use Google docs, but I wouldn't mind plugging it all in by hand. I've done so before when I used this site: http://jquery-datatables-column-filter.googlecode.com/svn/trunk/index.html to create a searchable database. I'm just wondering, however, how would I go about doing that with filter settings like the first site I mentioned. Any help would be great. Thanks!

Member Avatar
Member Avatar
+0 forum 3

Hello to all, I am working on a spreadsheet/database for my company to track our service calls for the equipment we sell. There are a total of three of us that travel to different locations. I have helped create a database that allows a user to enter information after completeing a service call. However, the interface is awesome and the company wants to use it as a service report as well. Problem is that service reports travel with the technician while the database is hosted on the server. Long story short, is there a way that I can make this …

Member Avatar
Member Avatar
+0 forum 3

Office 2007 on a Windows 7 PC. A user has an intermittent problem where when she copies a cell with a formula in it, clipboard picks it up as text. Typically, if one pastes a copied cell with a formula it also puts the formula in the cell. Not always with this one. Likewise the drag feature where one can grab the lower right corner of a cell and drag it down to past the contents of that cell into the cells below. Doesn't work sometimes. Similarly large numbers (13 digits) copied paste to a cell in text and are …

Member Avatar
Member Avatar
+0 forum 2

Firstly, im not sure if this is the correct location for a VBA question? Please move if necassary. This is my first major project using VBA - Ive previosuly used vb.net quite alot, and still adjusting to understand both, and the differences. My question is: I have a folder with at times none, and at others up to 10-20 .txt files. i want to loop through each file, and read each line from the file. I have predefined variables that i want to asssign each of these lines (according to the order of lines read) But im not sure how …

Member Avatar
Member Avatar
+0 forum 1

hi everyone i have made a program which extracts information from an email account, it extracts the date, the sender, number of copies written in the body, and it extracts the pdf file from the email and puts it into a directory, it also counts the number of pages in each pdf. i have strings setup so that in the python out put its outputs the date, teacher, copies, and pages. since there are more than one email, the uotput returns more than one oupt put, for example if there are two emails it will output two dates, two teachers, …

Member Avatar
Member Avatar
+0 forum 4

hi everyone i am currently building a program which logs into an email, extracts information like the date, sender, subject, number of copies, and takes any attachments and puts them into a directory, than takes the number of pages of the pdf. i have already built a program which does all of this(below is the program). now i am stuck i need to be able to put this information in to a spreadsheet for acounting in the following format. job Date teacher copies pages with the job number justing counting by 1's the date which is already in the generated …

Member Avatar
Member Avatar
+0 forum 5

Hello Everyone! So ive done some searching and havent been able to find what i need. Partly because i'm not sure exactly what words i should be googling! I am wanting to download gmail emails, and then display them in a spreadsheet like format. I know that emails have unique ID's and also the email content i am downloading has a unique "order number" in it as well. I think i can create a dictionary with the unique id's, but not sure where/what/how to put in a spreadsheet like format?... i have attached a picture of what im shooting for. …

Member Avatar
Member Avatar
+0 forum 1

Background: I have a Drupal site with around 150 users. Each of those users has a spreadsheet that they send to me weekly. I've uploaded all of the spreadsheets to an Editgrid account and I've created a custom drupal block to display there Live spreadsheet and edit it so removing the need to e-mail the sheet each week. At the moment i am using the following link embedded into the block, the section that is highlighted (name of the spreadsheet) i would like to be dynamic depending on the user viewing it (so i dont have to make a different …

Member Avatar
Member Avatar
+0 forum 1

I have a excel spreadsheet that contains the following information: part name, part number, calibration, rev. level and other information. I also have a form that I have to fill out every month using the information from the above mentioned spreadsheet. Is there a way to input the spreadsheet information to the form? I have to hand write this form every month and I'm looking for a way to keep from doing it. I need to be able to print for each month of the year. (I'm currently using excel 2003.) Any help with this would be much appreciated.

Member Avatar
Member Avatar
+0 forum 5

I am running Excel 2007 on Windows 7 Ultimate Edition 64-bit. I was sent a spreadsheet which uses the earlier Excel format (97 to 2003). I can open and edit it fine, but when I save I get a message saying that I am using features which are not compatible with that file format. All I did was bold my font and change its color to navy blue in each cell that I added. I was told to do this in order to distinguish my cells from the cells of my co-workers. I think it's something else though, because I've …

Member Avatar
Member Avatar
+0 forum 3

Hi All, I have a small problem that I am trying to solve...It regards storing string values in an array and outputting them to a .csv file. As you know the .csv file accepts inputs delimeted by commas ",", however the arrayed values are also delimeted by commas therefore $arr[$i]="1,2,3"; and this is read by the .csv file. My intent is to have the values "1,2,3" stored in a single-cell/column in the excel spreadsheet rather than have "1" in a separate cell and likewise for "2" and "3". Any ideas? I thank you for your response.

Member Avatar
Member Avatar
+0 forum 12

Hello, i am programming a spreadsheet as my assignment. I have done it but the last step is to make it so uncalculated cells linked to other uncalculated cells need to be calculated. meaning if A1 hold the formula A1 = a2+a3 and if A3 in turn holds another formula it needs to be calculated first. this has made me rethink my whole assignment. Can someone show me how to develop a simple spreadsheet console program which does that.

Member Avatar
Member Avatar
+0 forum 2

Following Google's announcement just yesterday that they are going to develop a full office suite for the web, they've just recently added a new feature to Google Spreadsheets: charts. This isn't quite your regular spreadsheet program, as it's still quite basic and was not much more than a portable way of storing data. But charts do a little bit more. This does show that Google is continuing on to challenge the existence of full-blown applications, creating nearly equivalent web applications that are often just as functional as their standalone counterparts. And simple isn't always bad; one thing that Google has …

Member Avatar
+0 forum 0

The End.