[excel] Forum Topics

Hi I dont think I ever untapped the powers of Excel for advanced analytics. Thus, as Im going through these tutorial books, I do wonder what are your tips to help you analyze data quickly and efficiently. Help!

Hi everyone, I need a script that will redirect an excel API from one database to another using VB.net. I am still a novice. I need your help. Thank you.

Ok, here's what I've got. I have a form that exports to an Excel worksheet (sheet1) and it works great, no issues there or anything. It's not a template, just a regular .xlsx spreadsheet, but I use it as my template. Now, the goal is for the end user to …

Hello everyone! Trying to setup a connection to a website to be able to update currently displayed data and push it on a regular basis to my spreadsheet. The link I have is a direct link to download the newly updated spreadsheet. I continue to get an error message when …

HI, pls help me in this.. How to import Excel Sheet data into SQL Server 2008.? i use Excel 2010. SQL Server 2008. how to import data? thanks in advance. jack

Adding excel data into hash table: [CODE] Hashtable ExcelSheets = new Hashtable(); System.Data.DataTable dt1 = new System.Data.DataTable(); da.Fill(dt1); System.Data.DataRow dr; //System.Data.DataColumn dc; #endregion # region adding excel file into hash table if (dt1.Rows.Count > 0) { for (int c = 0; c < dt1.Rows.Count; c++) { // if (c > …

Can anyone recommend an ODBC driver for Excel in VB 2010 Express? This is a 'legacy' problem having just being forced to move from VB6 to 2010. Any help well appreciated

I want to add first two columns of excel file into hashtable.. I wrote following code but it is giving me eror saying indexing not allowed in datacolumn... [CODE] Hashtable ExcelSheets = new Hashtable(); System.Data.DataColumn dc; // adding excel file into hash table if (dt1.Columns.Count > 0) { for (int …

Hi, I need to compare following xml file USING C#: [CODE] <Issue> <IpIssueId>790</IpIssueId> <IpIssueGuid>11</IpIssueGuid> <IssueName>Summary</IssueName> <RuleQuery>Rule1</RuleQuery> <Classification>R</Classification> <IssueError>Summary</IssueError> <Severity>100</Severity> <IssueFormat>Total domains: [[DomainCount]] </Issue> [/CODE] with excel file like: IssueName Type Summary Risk(R) bb Health(H) I need to verify whether "type" column of excel matches with "classification" tag of xml file.

Hi everyone! Im really stuggeling with excel. I do know how to import txt-files from web into excel, but when i do, the charset is wrong. So the Norwegian letters ÆØÅ is now wierd symbols (Ã¥Ã). This is not the case if im importing the text-file from a local folder. …

I am currently trying to take two columns from a *.csv file... log10 transform them, and then plot them up on a graph. The graph is not the issue, I just need to edit those two columns and plot them. The file does have a header row, there are 8 …

Is it possible to check which version of Excel a user's computer will open while in a VB6 application? Some users will be using Excel 2003 and some will be using Excel 2007 and, in theory, a single command button will open one of two excel sheets based on which …

Training management system: Hi, I want to build a webpage in a plain HTML, JavaScript, CSS. In this webpage, I want to build a TRAINING MANAGEMENT SYSTEM. Requirements: 1. A form which should take the trainee's unique id and process it. If the entered trainee ID matches with any of …

Hello all, I recently made a mysql database using python and imported an excel file into the database. However, I am having some issues with some of the python. Using the following code, I have selected 11 numbers from a table in the database. # c.execute('SELECT REF_PNL FROM actual_data_table WHERE …

Hello, I have a problem opening Excel file which I have created using a xslt. Actually, I had a xml file which I transformed to an excel file and saved. I don’t know how to open it. Everything I have tried, didn’t work. Please, if someone knows the answer...

Hello everyone, I currently have an application that reads in an entire excel file then iterates through the records from the file and queries our database for a match. If a match is found the record is ignored if a match is not found the record gets added to the …

I am using Excel interop in my VB.NET program. My problem is that I can't seem to figure out how to write to Excel *and* define the Range using numbers. Alright, so I have objects being created depending on the file that the user opens. So there could be 100 …

Anyone played with the jxl API before? It's a tool for read/write access to Excel spreadsheets - a little bit dodgy, but it works. I wrote a piece of code for my brother using this a few months ago, and now he's starting to see a warning message, which is …

hi there, i am new user of C++. i have to write a code for my final year thesis work though my subject is naval architecture. I did my coding perfectly. But i need to take the result in excel file. the problem is ,using outfile command , the whole …

Hi there, I have a question regarding excel in C#. I have a datagridview and in that I have a datagridview cell button to open an excel file and make it visible, and another to upload to save the file to a folder in a project folder, I add the …

I am trying to implement an application in which a Perl script uses Win32::OLE to populate a spreadsheet from a database and present it to the user. The user is then free to modify the spreadsheet [I]manually[/I]. The modified data is then required to update the database. We would prefer …

Hi, I have a question relating to excel sheets in C#. I have a button in a datagridview in C#, how can I open an excel sheet when I click on the button. And then when the excel sheet opens I need to edit it, so how can I open …

Hey guys, I have 200 documents in similar structure and I want to extract data to excel file. What is the easiest way? Thanks

Hi all, I'm writing an application that imports and tidy up address data into a cleaned, deduped excel workbook ordered in rows with each column as an address field. One of the issues I've ran into is that we sometimes get a workbook where the multiple address fields are held …

I am using VB.net 2008 express edition I have figured out how to use some of the code snippets for the open xml sdk to create a drop down list of all the sheets in an excel file. I can also use the code snippet to get the value of …

I have a .NET winforms app that automates Excel and checks for a worksheet password. The requirements are to be able to detect 1) that the protection is turned off 2) that the password is removed (protected but there is no password) 3) that the password matches the correct password …

hi! does anyone know how to convert excel file (xls and xlsx)(or even just xls) into csv preferably using xlrd and csv modules. i need to convert a specific excel sheet to csv. i need to create a csv file instead of using comma but semicolon. i am still not …

Here is a free excel to tab file convertor. Feel free to use for whatever purpose you want. There is no need for excel to be installed on the host pc. Assumes the user is on a windows platform. Extract all three files into one folder and run the main …

Hey people, first all let me apologise if this in the wrong section I couldnt find a seciton for office or just excel. So i figured windows software was my second safest bet, he hopes lol. I'm having a problem with excel. I'm trying to write a function that will …

Hello, I put together a small tutorial that I wanted to share. I found only scattered information on this and put a more complete tutorial together with code and comments. [URL="http://blog.ajwilhelm.net/archives/7"]Parsing Excel files with Python[/URL]