Search DaniWeb - spreadsheet

Re: Top industries that use automation 2 Months Ago by Reverend Jim …. This is no more automation than is output from a spreadsheet. i'm not sure where I stand yet on self… spreadsheet won't fit in a single page 17 Years Ago by tgifgemini … access table (file). when I print the data in the spreadsheet, part of the data prints on one page and the… spreadsheet console program help 15 Years Ago by notuserfriendly Hello, i am programming a spreadsheet as my assignment. I have done it but the last … assignment. Can someone show me how to develop a simple spreadsheet console program which does that. Spreadsheet App for iWork 19 Years Ago by Revloflandisher Any chance we'll see a spreadsheet application added to the "iWork" suite, in the next year? [url]http://home.mindspring.com/~revloflandisher/getamac/[/url] :o Spreadsheet to text 17 Years Ago by stuw I would like to input a spreadsheet and convert it to a text file and then manipulate it. I don't want to have to open Excel to do this. I'm just slightly above the noob stage. I only have VB5 at this time. Thanx in advance for any help!! Stu VB6 - Spreadsheet generates blank pages with no records. 17 Years Ago by tgifgemini …Columns("L:N").ColumnWidth = 10 'Populate Spreadsheet: '--------------------- M.qBW.MoveFirst rsinPers.MoveFirst ii = 5…M.qBW.MoveNext Loop 'Adding an invisible comment to spreadsheet: '------------------------------------------- 'xlWksht.Cells(ii + 3, 1).AddComment … Excel spreadsheet columns need to be resized on open - everytime 17 Years Ago by km_gater …of the columns of the same Excel spreadsheet every time he opens it. This spreadsheet is updated by one person in … it. When I open this spreadsheet the layout is fine. The person updating the spreadsheet has got all the columns formatted… be others that haven't said anything) opens the spreadsheet several of the columns are sized too small to see… Writing to a spreadsheet 16 Years Ago by g_loughnan Hi Lads, I'm trying to read from one spreadsheet, extract the contents of certain cells, and write …them into a new spreadsheet. I've read from one spreadsheet fine, but when I try to … = Workbook.getWorkbook(new File("C:/Documents and Settings/spreadsheet.xls")); Workbook workbook2 = Workbook.getWorkbook(new File("… Embedding a spreadsheet and chart into a windows form 18 Years Ago by C#4fun …. The problem is in getting the chart bound to the spreadsheet data. I cannot figgure out or find help in searches… code, or link it to a spreadsheet so the chart will update automaticly when the spreadsheet is updated. The help I have… updated, and also that it can be bound to a spreadsheet. P.S., not a student any more. If it was… Data in spreadsheet is not printing on same page 17 Years Ago by tgifgemini … printing problem. I generated a spreadsheet using an access file. The data in the spreadsheet stretches all the way from Column…columns N through S prints on another page, splitting the spreadsheet data into two separate pages. How can I get the… whole spreadsheet to print on one page: I mean columns A … VB6 - Spreadsheet "MergeCells" not working 17 Years Ago by tgifgemini … am using similar code and technique to format another spreadsheet, but it is not working. Maybe there is… code. I have attached two spreadsheets: The first spreadsheet is correctly formated and the second is not formating …correctly( Unformated) I want to format the second spreadsheet to look like the first. See my module below: … VB 6.0 - Some Data in spreadsheet rows are not visible 17 Years Ago by tgifgemini … a display problem within my spreadsheet. The data in the spreadsheet row is hidden. Looking at the spreadsheet, you will see that the… effect, but it's not working anymore. Please see the spreadsheet attachment to get an idea of what I am talking… Using an Excel Spreadsheet as an Argument for a Python Script 13 Years Ago by kayoh … the title says, I want to implement using an excel spreadsheet as an argument for a python script. I already have… the layout of the spreadsheet, but I want to be able to assign the variables… in my python script from specific cells of the spreadsheet. So, ideally I want to be able to type something… Python, Help with displaying records in spreadsheet 13 Years Ago by xopenex … to download gmail emails, and then display them in a spreadsheet like format. I know that emails have unique ID's… i am going to make the records selectable in the spreadsheet and then send them to other people with the click…... i have the sending stuff figured out.. just need the spreadsheet stuff! thanks guys... and im also going to have a… HELP! creating a spreadsheet and input information from python output 13 Years Ago by ozzyx123 … to be able to put this information in to a spreadsheet for acounting in the following format. job Date teacher copies… there any other script i can use to create the spreadsheet im looking for. another question i have is since i… i get, how can i input this information on a spreadsheet on different cells? if anyone could help it would be… View Excel spreadsheet in ASP.net with dynamic labels 11 Years Ago by rubenrav My company is using a simple spreadsheet to write down things from control…a database, I want to view this same spreadsheet in a ASP.NET page, with the textboxes… filled in. The spreadsheet is so complex graphicly, so i don't… been thinking about make a picturebox of the spreadsheet and then have dynamic labels upon it, but… Re: Using an Excel Spreadsheet as an Argument for a Python Script 13 Years Ago by Gribouillis You only need to read the spreadsheet file in sys.argv and use the module xlrd [code=…;__main__": assert len(sys.argv) == 2 spreadsheet = sys.argv[-1] wb = xlrd.open_workbook(spreadsheet) sh = wb.sheet_by_index(0) my_variable = sh.cell_value… Re: HELP! creating a spreadsheet and input information from python output 13 Years Ago by ozzyx123 … to work and now i am able to create a spreadsheet. i am trying to input the information i have into… the spreadsheet and i am having some problems. Basically i have some… of the strings into a separate cell. i want the spreadsheet to to have job Date teacher copies pages as the… Re: HELP! creating a spreadsheet and input information from python output 13 Years Ago by ozzyx123 [QUOTE=Gribouillis;1775436]I think you should forget about the spreadsheet first and print your expected output to the console with … be easy to convert the code to write in a spreadsheet.[/QUOTE] i really am stuck because im not sure what…) i just need it to put the information on the spreadsheet. i am able to make my program out put all… VB code to clear entire spreadsheet data (contents) 17 Years Ago by tgifgemini … smart folks. I am populating an excel spreadsheet. Each time, I want to clear the spreadsheet content before repopulating it. I am… and it is clearing the first 3 rows in the spreadsheet and every other data stays in tact. This is is… VB6 - Merge Cells in spreadsheet 17 Years Ago by tgifgemini Hello all, I am populating a spreadsheet with data from access file. I am splitting each …row to be extremely large, disfiguring the look of the spreadsheet. What code I use to expand that second row …; rsin![Comments] [/code] Below is the code that populates the spreadsheet: [code] Do Until rsin.EOF = True ii = ii + 2 … Re: VB6 - Spreadsheet "MergeCells" not working 17 Years Ago by tgifgemini … any of you good people have an idea why my spreadsheet is not formating properly? I have tweaked and tweaked but… first record. Please see attachment for the sample of my spreadsheet. Thanks. Below is my entire Module: [code] ii = 5 w… VB 6.0 - How to programatically add a comment to spreadsheet 17 Years Ago by tgifgemini Good people, Please can someone show me how I can add a permanent comment to the end (footer) of my spreadsheet. I want this comment to be visible when the spreadsheet is printed. I know how to add the comment on the spreadsheet that is visible only when you hover the cursor on it. But I want to hard-code it in my module. Thanks, tgifgemini How to: Excel Spreadsheet online?? 17 Years Ago by MKIII Hello all, i'm trying to have an excel spreadsheet online (with a url) like I've seen done before, …'ve saved the spreadhseet as a webpage, I inserted the spreadsheet onto my webpage and publised the page. The question is…, how does one continually save the spreadsheet??? I would like people to enter data and I would… VB6 - spreadsheet - Format text Indent paragraphs 17 Years Ago by tgifgemini …formats the "Comments" field row in my spreadsheet. The objective is to begin a new paragraph whenever…is currently formating the "comments" field in the spreadsheet: [U]Example 1:[/U] Comments: [B]9/10/…there any possibility of tweaking the code to format the spreadsheet such that after writting "Comments:" it … Re: Excel spreadsheet columns need to be resized on open - everytime 17 Years Ago by MidiMagic Look for the following: - Two versions of the file in different folders. - A cached version of the file. - A macro intended for a different spreadsheet is running when Excel opens. Database vs. Spreadsheet 17 Years Ago by knight fyre … in the amount owed/paid columns. I used an Excel spreadsheet to do the job, most of her requirements anyway. :$. I… on my part[/I]). Should I continue working with the spreadsheet or would an Access Database file work better in this…situation? When is a database the better choice vs a spreadsheet and vice versa for a small to medium number of… Word macro to open and Excel spreadsheet needed 16 Years Ago by JosephGassmann … help with writing a Word macro to open an Excel spreadsheet. Long story short is that our firm has a multitude… different documents and other functions. We now have an excel spreadsheet that we would like to add to that list of… a macro in word that will open Excel with that spreadsheet? If so, can you give me a sample code for… Read spreadsheet (.xlm or .xls) into mysql database 15 Years Ago by futhonguy … trying to write/modify a script to read from a spreadsheet into mysql database using php. I did a search on… managed to find an open script to read from excel spreadsheet onto the explorer. Can anyone able to assist me how… where i can find relevant resources to read from a spreadsheet and insert into mysql database table? Cheers Futhon. Compare and Update database from excel spreadsheet 15 Years Ago by futhonguy … in the server. This update comes from an Excel spreadsheet. I did search on Google/Yahoo and found websites …PHPExcelReader or PHPExcel. My idea was to read from the spreadsheet and stored the information into the database server. from …update the existing data with the new information from the spreadsheet. I am not sure if this is the right…