[excel] Forum Topics

Hi so i'm working on a project in c#. I have hundreds of xml files and I need to extract 6 values from each of the xml files and somehow display them on an excel datasheet. Here is an example of the xml file: [code] <XAxisCalib> <Max>288.93</Max> <Min>-48.08</Min> <MaxS>200</MaxS> <DfTHt>0</DfTHt> …

I got an assignment to search in a certain excel worksheet which I'm using the Find & Replace dialog of excel all I want is to make a VB6 program that will going to load the excel data into VB6 flexgrid and search hundred of words in a one click …

Hey guys, Just as 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. …

Hello i have problem in my software, i want to read file excel and compare data. If i use file excel with small size it run succesfully, but if i use large file i have fault. Please some body help me

Hi guys Can anyone help me with this one? I want to insert a loop in my code to read all the data in excel file here's a portion of my code. [CODE] private void btnUpdate_Click(object sender, EventArgs e) { string directory = "D:/myFile.xls"; if (File.Exists(directory)) { Excel._Application myPartFile = …

Hello, I have to append 30 Excel 2007 files, each with 6700 columns, into one. The problem is that in these files the columns are not in the same order(the column names are the same in all the files). Im having Python27 with openpyxl, Win7, MS Office 2007, MS SQL …

So I've set up a data connection to a table on my website and the data imports just fine, but it formats the cells wrong. Case in point: The text coming in is "May 7". First Excel auto-converts this to "5/7/2011". But then it doesn't even display that, it displays …

Hi everyone, I have a code which converts a html page into excel file. The following code has been working well so far, but Im having a problem of converting the html page into excel file after I had changed the localhost to another server. It's not able to generate …

Hello All Experts Please tell. Can I use Microsoft Excel Sheet in c sharp as addition of Students Monthly fee And save it in SQL Server ?

Hello for all i want to collected data from pdf form inserted in excel spredsheet i try many methode and some program for (PDF to Excel) but not work i have acrobat x pro and my pdf form (text,number ,pictures). and get data for all it's possible if any body …

Hi all I'm looking to do what as far as I know is a straight forward enough task in excel...............just can't think the best way of doing it!! I am taking registrations for a course and I have two columns (K&L) for paid and fee Column L is the fee …

i have two dbf that should write in excel file,,ive already done writing on the first table my problem is how can i join the other table from the other but theyre not going to combine,,first table id in the upper part and the second table is in lower part,,

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 …

Basically, it is an open source software creation application that revolves around databases (similar to Microsoft Visual studio in some aspects but with python as the language). The user will be able to create forms with a drag and drop GUI builder, create an SQLite database and add functionality to …

Hi, Does anyone know on how to convert vb.net to excel. I am new in this company and they are using Microsoft SQL Server Management Studio for their database. FYI, they are using stored procedure as well. Thank you

Hi Everyone, Can somebody please help me with this. I have this gridview and I have binded it properly, now I have a button and I want to export the data inside the datagrid to excel. I can do this in asp.net because the code is quite easy for the …

I have loaded a .TXT file into an array, and want to display each of the posts in the array in a grid. Any pointers how to start attacking this beast? Have tried using Datagrid, and failed :( I have a "Learn by doing" approach to VB.NET, so I need …

I have this code: [CODE]import csv tally=0 i=0 n=1 numb=2 count = sum(1 for row in csv.reader( open('cities.csv') ) ) cityname = csv.reader(open("cities.csv", "rb")) citynames = [] citynames.extend(cityname) for data in citynames: citynames.append(data[0]) tally+=1 if tally>=count: break tally=0 cities_x = csv.reader(open("cities.csv", "rb")) cities_list_x = [] cities_list_x.extend(cities_x) names = [] for …

hi, i have a destop application and i have data in 4 arrays, what i want to do is to open an excel file and then add the array data into the excel file, nd then save the excel file . please how can i do it i tryied using …

I am creating a Delphi program that needs to extract data from our database and create an Excel report. I would prefer to use the Delphi components TExcelApplication, TExcelWorkbook and TExcelWorksheet, but I haven't been able to get them to work. Most of the examples I have found are fairly …

Dear Helpful Members of Daniweb, I have been working on several projects to automate work in the company I am working for and have come to the following problem: I have a VBA6 program I have successfully programmed to calculate the costs of our fasteners and anchors, now it is …

Who remembers Clippy?[ATTACH=LEFT]18033[/ATTACH]

I've got a funky situation here that I think a script could solve, but I'm no good at scripting Excel, so there! It's Excel 2007 btw. My online store exports a CSV of orders along with the line items of the order. To accomplish this, it outputs one row as …

I have two data gridveiw in my form, in one data grid I am importing excel file to display all the data which is working fine, now I need to extract some columns data from main gird which is holding all the data and display in to another DataGrid which …

Hello! I'm trying to find a code to delete multiple columns because when you delete a column the next column takes his place so for example: If you delete column 6 then column 7 becomes column six. I tried the following code with an for loop & a while loop: …

Hello world, I need your help/advice, I have a table last_acces where inserting a few data. The table columns are: Id Name Date I want to export this data into excel clicking on the link or button from the page. Anyone could help me on this please? The action will …

Hello, I have a layout and i have to paste information on that layout, in that lay i have Columns H, P i have a formula in column P like this [CODE] =IF(ISERROR(P3/H3),0,P3/H3) [/CODE] but when i insert the information obtained in VBN to EXCEL worksheet it pastes the information …

Is it possible to read and write excel files on PHP4? If yes, how? Thanks

Sorry - I know this isn't strictly Python, and i'm more asking for a formula than code! Usually Excel functions show how they are calculated but i can't find anything on this one! So given a set of data, predict what the next value will be based on the previous …

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 …