23 Topics

Member Avatar for
Member Avatar for jonsan32

A developer from India helped me create a pretty cool page, but he's since abadoned me with a few errors in his code. On my [ROSTERS](https://fiftyallstars.com/p/rosters.html) page for my basketball program, it's meant to display cells generated from [this Google Spreadsheet](https://docs.google.com/spreadsheets/d/e/2PACX-1vQd232Tmdvi3iaqni-Gc_RR0d0he9k2Dkel5A7uJU-GWUdck4CFecru3K2HfrybyI3pfrpAMpM4XZOa/pubhtml). Only problem is it works for most grades, but …

Member Avatar for Halla_1
1
1K
Member Avatar for Reverend Jim

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 for Reverend Jim
7
9K
Member Avatar for ggeoff

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 …

Member Avatar for bobbyraw
0
234
Member Avatar for CoilFyzx

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 …

Member Avatar for CoilFyzx
0
283
Member Avatar for karmstrong

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 …

Member Avatar for dashing.adamhughes
0
249
Member Avatar for rb1234567

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 …

Member Avatar for patk570
0
288
Member Avatar for IsaacMessi10

Sheet1 A1: Football A2: Rugby A3: Basketball Sheet2: A1: A2 A2: B4 How can I get a location of a field from String? Is it even possible? *eg. I want to tell the contents of cell A2 in Sheet1 by getting the string value "A2" from cell ''Sheet2'!A1'*

0
139
Member Avatar for minuteman263

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 …

Member Avatar for minuteman263
0
306
Member Avatar for ffej2ffej

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 …

Member Avatar for iamthwee
0
190
Member Avatar for jonsan32

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 …

Member Avatar for AleMonteiro
0
215
Member Avatar for Radio2006

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 …

Member Avatar for Radio2006
0
220
Member Avatar for joshl_1995

Hello Community, I was wondering if there is a way to make a program that will copy text from an excel spreatsheet and place it in another using visualbasic.net not vba? Please Help

Member Avatar for Reverend Jim
0
268
Member Avatar for clarkcomputer

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 …

Member Avatar for dee101g
0
263
Member Avatar for Gobble45

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 …

Member Avatar for Gobble45
0
258
Member Avatar for ozzyx123

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 …

Member Avatar for ozzyx123
0
1K
Member Avatar for ozzyx123

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 …

Member Avatar for peter_budo
0
650
Member Avatar for xopenex

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 …

Member Avatar for xopenex
0
205
Member Avatar for ecdmonkey

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 …

Member Avatar for ecdmonkey
0
266
Member Avatar for barney789

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 …

Member Avatar for barney789
0
256
Member Avatar for NotThereAnymore

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 …

Member Avatar for jaydeee
0
217
Member Avatar for ibdatx

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"; …

Member Avatar for fredfletcher
0
811
Member Avatar for notuserfriendly

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 …

Member Avatar for notuserfriendly
0
183
Member Avatar for John A

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 …

0
181

The End.