629 Topics
 | |
| | 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 … |
| | Hello, I have a small office with 4 employees. We all work off of laptops (although I am about to bring a desktop in because I need a little more horsepower for some graphic stuff). I have a number of files I would like everybody to share, update and save …  |
 | 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 … |
| | helo friends. i need to deal with more than 10 excel sheets.. so i want to make an desktop application in Visual Studio(c#), which performs as followings..: 1) first user can choose on which file he wants to work on. 2) then retrieving column wise data, and performing many mathematical … |
| | Hello I am looking to dump data from a MySQL database to an excel spreadsheet. I know I can dump it to a CSV file and import that way, no problem. But I want to dump the data to a specific spreadsheet in an excel and specific cells. I have … |
| | I will get an Excel 2003 file everyday via email. This file has 5 columns. The first for columns have static headers and text in them. The 5th column is the date of the report and below that is a list of values in the same column, followed by an … |
| | I have a jsp page which is showing data in that page from DB.there is also a facility to show data in excel file.So there is a link to import the data in excel file. I have noted down that url by pointing the cursor to that link that is …  |
| | Hi All, I am developing an Excel Add-in using Visual Studio Tools for Office using C#. However, the problem is that i want to use the SOLVER add-in that is available in Excel in my code. I cannot find any way or documentation anywhere for doing the same. However i … |
| | hi, i found a module called xlwt ([url]http://www.python-excel.org/[/url]) that can write to Excel. i want the code to read from a file (robert.txt) and then write to excel in a column. however, it seems that the output from this code is that it only writes to one cell in the … |
| | Hi everyone, I hope you could help me with my problem I am a fresh graduate and I am working now as a developer in a good company By the way, I am not the one who developed this tool, it's the previous programmer and they gave the project to … |
| | hi... can someone please explain how to create a new excel file using an excel template in c# I have no idea how to go about doing it and that is why i haven't pasted any code.... i have been developing an application as part of my college project..... and …  |
| | Hello all, I need to extract data from a website, say for eg. Buy.com's Electronics category and save it either in MS excel. I tried looking for the code over the internet, but this wasn't properly explained anywhere. Please help me. |
 | I think the title says most of it. How do I, in MS Access using VBA, get information from a workbook which I can then put in as a recordset in a table? I know that excel has an easy workaround for other excel workbooks, and I've read somewhere how … |
| | What is the fasted way to delete rows based on a condition in Column A using VBA? Anybody have an example? Thanks. |
| | Hi, I'm trying to create an excel 2003 workbook from my vb.net project I referenced the code from this website [url]http://www.dotnetspider.com/resources/20382-To-create-Excel-file-vb-net.aspx[/url] However i'm getting error on this line "objSheets = objBook.Worksheets" Can any please tell me what's wrong? [CODE]Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click … |
The End.