629 Topics
 | |
| | Hi, I have a program that needs to create a downloadable excel template with the following headers on the first row named, name, age, gender. And I also want the template to only have 1 sheet on it. how can I create a sample template using vb.net code? Thanks |
| | Hi, I just have this program that needs to create a downloadable template for the excel file that will be used later in my program, now I have this templates in my server and I think that i'll just import this file first and then put it in the data … |
| | Hi, I have this program that uses OLEDB connection to import excel file to data table then use it in other functions. Now I have this question: What are the possible limitations of OLEDB when it reads the Excel file. The File is on xls format, and I want to … |
| | Hi, I have this code that will import the excel sheet to the datatable then inserts it in the database, but I have this problem. I have set the HDR to yes so that the first row will be considered as its header, but the problem now is that if … |
| | please find attached screen prints on how my data looks on XL sheet (as-is). With the help of Macros, I need to cut every 4 columns and need to paste it in a different XL TAB. I have attached another Attachment which gives how my data should look once Macro …  |
| | Hi, I have this program that uses OLEDB connection to open the excel file, and imports it's data. Then I use mysql connection to inserts all this data. Now my question is, is it possible that I can use mysql connection in opening the excel file, or only OLEDB connection … |
 | I have an application that needs to know how many excel rows are in a worksheet before they are imported into my application. at the moment I am asking the end user to enter this into a text box, but would like my application to do this can anyone suggest … |
| | I have this question. I have already imported all the excel data in the datatable, but now I want them stored in a 2 dimensional array, meaning I want to have this kind of thing in the array, something like array[x][y], where x is the row and y is the …  |
 | How to deactivate updating of microsoft office 2010 |
| | Need help, I need to know on how can VB.net validates the format of each cell on the excel file that it opens, for example, the first row should only be numeric, or cannot be null, is it possible that vb.net can check it before it inserts it in the … |
| | Hi, I am having problem with my coding below when I would like to export the data from GridView to Excel Spreadsheet. Appreciate if you could share your valuable comment. Thanks [B]Error Message =[/B] Class 'System.Web.UI.WebControls.GridView' cannot be indexed becasue it has no default property. [B]Error Line[/B] = xlWorkSheet.Cells(i + …  |
 | Hi I have two desktops one has Office 2003 and the other my "graphics and video PC" has Adobe Creative Suite 3 Design Premium. Both use XP Pro. I can't use Adobe Acrobat as MS Word is installed on my other PC. There are a few other issues, that lead … |
| | [CODE]using Excel = Microsoft.Office.Interop.Excel; namespace program { private void cmdOpen_Click(object sender, System.EventArgs e) { FileSystem.FileOpen(1, inputfile, OpenMode.Input, (OpenAccess)(-1), (OpenShare)(-1), -1); // 1 : excel file Excel.Application MyXl; MyXl = new Excel.ApplicationClass(); MyXl.Visible = true; Excel.Workbook xlWorkbook = MyXl.Workbooks.Open(inputfile, 0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "", true, false, 0, true, …  |
| | // ws is an object variable of worksheet // systype is a string variable Range r = (Range)ws.Cells[2, 2]; systype = r.Value2.ToString(); how can I combine these two lines into one single line ? Please help .... |
 | Hello Everyone, I want to transfer data in export from my php reports. it works also. but the problem is when i open that .xls file in notepad i can view all my data. i don't want this.my data will be unsecure.can anybody tell me solution?? code is as below: …  |
| | Greeting fellow Humans, I'm trying to "[I]comb merge[/I]" (if any thing as such) bunch of Excel files. There are 2 type of Excel workbook: A & B Both has a column called : [I]Location ID[/I] [U]These are the step I think the prog should do [/U]: Promp user to select … |
| | Hi everybody. I have a simple problem. Need send the c++ output to excel(csv->xls or xls direct) in formated data. I can send the data to excel, but i can´t format that like this: |_ col 1__|___col 2___|___col n____| row 1......|....2row 1 row 2......|....2row 2 row 3......|... 2row n What … |
 | =rand(100,1000) type this on your ms office if you have then a magic will happen...  |
| | I am trying to write a windows application in vb.net to import data from excel to sql server. I got "object not set to an instance of an object" error. The data actually have been inserted into the sql. The following is my code. I have a button when the …  |
| | I recently formatted my hard drive and I've re-installed Office, all my OneNote notebooks are synced to the cloud. I opened OneNote, newly installed, and signed into my Skydrive account but nothing syncs, nothing downloads from the server, so I have no notebooks. Opening Skydrive in a browser and downloading … |
| | Hi all, I wrote a .hta script (with vbscript - no jscript, in it) and put it on a fileserver. The people who use this script, start the script by clicking on a shortcut on their Desktop that leads to the .hta script on the fileserver. The .hta script reads … |
 | Hello everyone, I'm a java programmer writing a half graphical half text rpg. For the moment I read my data from text files, e.g. Enemies.txt id name hp and so forth. However, I want to make it a little more clear to handle, as in a database format. I can … |
| | [COLOR="Green"]Hi all Pls tell me how i can read a data from EXCEL file and copy it to a text file using c++ program.I dont want to do it as manually .(Its for an extended application for software).I want to read the data from perticular cell to the end of …  |
| | I know this forum isn't to give away the answers, but could someone maybe help me get started? My biggest problem is figuring out where to start. Even the pseudo code doesn't help me very much. I don't know how to use an excel file in a program either. I … |
| | Hello Members, Would anyone please take a look at my attached excel files which is a commodity exchange's end of the day data file. This is a free copy which anyone can download from their websites. Those are ([url]www.mcxindia.com[/url]) & ([url]www.ncdex.com[/url]). Now my query is in those two files there … |
| | hello friends, i have a windows project in vb.net, in which i have to connect my project with an excel database i have microsoft office 2007 installed on my lappy.. please help me with the code. thanks in advance.. |
| | Hello, as anyone reading this might have guessed I need help. And please forgive me for making it long. [COLOR="Green"]You may skip right to [B]Found Half of a Solution[/B] if you don't want/need the background of my problem.[/COLOR] [B][U]Why and What[/U][/B] I am developping for a client an Excel worksheet … |
| | Hello, I'm still trying to work out the same problem: how to process data from an Excel sheet (above all sort through it but in groups; will explain further down) to use in a Cluster Chart without storing it as data in an Excel sheet. The problem at hand: I … |
| | Hello, it now seems that I might be able to use SQL/MS Query to do what I tried to find a [URL="http://www.daniweb.com/software-development/visual-basic-4-5-6/threads/388319"]workaround[/URL]. (Even if this works that does not invalidate the problem posed in that thread, though its urgency would be reduced.) So: is there a way to perform in … |
| | Hello guys, I've been to a lot of forums and discussions about this but I never found precise solution. I'm having a WEB application in ASP.NET written in C# and a MySQL database behind. I made a button "Import from Excel" which has SQL command: "LOAD DATA INFILE 'importTest2MorePads.csv' INTO … |
The End.