534 Topics
|
|
|
|
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 …
|
|
|
I am trying to create an Excel sheet and save it in server... Once it is saved, I display a link to the user "download excel". He can click it and then download it.. The pblm is I cant save the excel it says "The file could not be accessed." …
|
|
|
How do I add a Macro to an Excel Sheet using Late Binding? I had the code working using Excel(2010) PIA: [CODE] //create a new VBA control module oModule = oWorkbook.VBProject.VBComponents.Add(VBIDE.vbext_ComponentType.vbext_ct_StdModule); //Add the VBA macro to the new code module oModule.CodeModule.AddFromString(sCode) //sCode is the VBA macro I created;[/CODE] I now …
|
|
|
I'm using VBA to query and modify an Excel database. The database contains information about servers and their locations. Most of the rack mount servers have the location column as something like "G-05". Those are easy. When it comes to the blade servers, the locations are listed as "G-05E2S09" or … 
|
|
|
Hello, everyone, My question deals with Excel, and not Access, but I understand they should be roughly the same. I have an Excel worksheet which contains several tables. The tables are actually named ranges; basically, I grabbed an area, gave it a name, and -voila!- it is a table. Until …
|
|
|
Okay, so I've been searching the internet for hours trying to find the solution to my problem. Many came close, but didn't describe exactly what I want to do. I have an excel file that displays the names, locations and other information about certain servers for work. I want to …
|
|
|
I have a spreadsheet for each month of 2010 (Jan-Dec) that is used to track church members donations by month. Under each month I have the last name, first name and weekly donation with the monthly donation total at the end of the row. I would like to output on … 
|
|
|
good evening everyone.. im a student and currently taking my thesis...im having a problem with creating a excel file with vb... the thing is I need to open the excel file inside the form in vb.net... Anyone please need help...
|
|
|
Hi All, I am trying to output an excel workbook that I created else where in the program through a Response.Write() call. The issue I am having is that when I call the Response.Write(); it shows the download dialog for the excel file which it is supposed, but when opened, …
|
|
|
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"; …
|
|
|
|
|
I want to bring data from certain cells in an Excel workbook into a datatable. The Excel is 97 - 2003 and is in \Box_zero.xls. The code snippet below gives an error "Could not find installable ISAM". From what I see in the literature, this error often means that there …
|
|
|
I’m trying to automatically save an excel file to pdf file using visual basic. So, I will manually open the excel, upon opening the excel file, it will run code to calculate a daily totalizer (this I have functioning) as soon as this code finishes, I want the excel file …
|
|
|
What is the connection string to write for importing mixed data from excel sheet to data grid My problem is, I have rows like 1 2 3 4 5 6 7 8 9 a b c d in excel sheet.But when I imported these rows only 1-9 imported succesfully but … |
|
In my form I have a graphic in a picturebox- simple stuff. My application prints a bunch of stuff to an Excel file- everything works perfectly with no problems. I need the image in the picturebox to print to the Excel sheet. I've tried a ton of code but nothing … |
|
|
Originally I was using Office Interop to import data, but that was a headache and a half for both me and my computer. Right now I'm attempting to load it with ACE, but my data grid isn't being populated. Once that's up and running I need to know how to …
|
|
|
hi im trying to create a small excel addin in VS2008 byt i cant figure out how to write lika a string or an int to a specific cell? for example: i want to write something in cell B1? how do i do that in the C# code? it must …
|
|
|
I am programing VBA for excel and was wondering if anyone knows where I can fidn the documentation for the selection object. Also do you know how I can get the VB editor to recognize thet object so when I type Selection and put the period after it, it pops …
|
|
|
Hi, I have this code. It is not working properly. Anybody may know the solution? Thank you [CODE]<?php include 'admin_homepage.php' ?> <div id="sidebar1"> <b></b><br /></br></br><img src="MMU_logo.jpg" width="180" height="150"/><br /> <a href="admin_view_student.php" style="font-size:13px" >View Student</a><br /> <a href="admin_new_student_reg.php" style="font-size:13px">Add Student</a><br /> <a href="student_excel.php" style="font-size:13px">Get Excel File</a><br /> <a href="student_mailing_list.php" style="font-size:13px">Get Mailing …
|
The End.