[excel] Forum Topics

Hi everyone i have a connection to my sheet like this Dim da As New OleDbDataAdapter("Select * from [EBU 2 LOB$]", con) but i want to use this Dim Sheet1_EBU as string = "EBU 2 LOB$" so that the code will be something like this i think? Dim da As …

hi all i am reading excel file from c# into dataset everything working fine but the problem is it takes first row of excel as header's of column and i have "TRANSACTION DATA FOR CDs MANAGED BY TCBILs FOR THE MONTH OF DECEMBER 2012" in first row of excel ant …

hi, I have a sheet name 'rate' and another sheet name "master". rate sheet has data as below EmpCol1 rateCol1 a 1 b 2 c 3 etc... and master has data as empCol2 rateCol2 c a b What i want to do is to get the rateCol1 from rate sheet …

'the code is working properly only problem with this code is when the first line ends in excel and data is inserted in next Row "instead of inserting another row it copies the same content which is inseted last time in form "

Hello its me again... sorry to keep on posting about my problem well here it goes.. If you see in the attached file.  I have an AM Ervielette, Marriane etc. now i need to add their Total Calls for Ervie and Total Visits same goes to the other.. …

I'm still getting my feet wet with Java and I'm not familiar with all the custom libraries that exist; is anyone familiar with a library for working with multiple sheets of a Excel workbook? I need to pull data from a specific worksheet in the book to work with.

Help i need to import excel to my listview using adodb or oledb but i dont know how? in vb6 i use adodb and the code is like here Dim lngI as Long Dim lvItem as listItem *'adodb connection goes here...* *'then this code will import all excel data in …

So there is a problem: I get data from the internet in table form( currency),and i want to get it into the chart form,and after refreshing-it could show the same as real forex trading platforms. And sorry for typing not in right direction, VBA close to /excel..and couldn't find any …

Hi, I want to know what code should be used in order for me to import data from an excel file to dataset and then adding it to the database, how can it be done? thanks

Hello to all, I am working on a spreadsheet/database for my company to track our service calls for the equipment we sell. There are a total of three of us that travel to different locations. I have helped create a database that allows a user to enter information after completeing …

I am getting an error..Need help.. " Parse error: syntax error, unexpected T_STRING in C:\xampp\htdocs\test2.php on line 24"; line 24 is --"header("Content-Type: application/xls");"-- <?php $DB_Server = "localhost"; //MySQL Server $DB_Username = "root"; //MySQL Username $DB_Password = ""; //MySQL Password $DB_DBName = "test"; //MySQL Database Name $DB_TBLName = "sample"; //MySQL Table …

I have a barcode scanner. So when the barcode is scanned using a gun, the value normally is entered to textfield placed on the screen. So I have made an excel macro. And when the barcode is scanned, the text appears on the cell ending with the new line character …

is it possible to load the data contained in an Excel file into a MySQL table using PHP?

Hello Community, I was wondering if there is a way to make a program that will copy text from an excel spreatsheet and place it in another using visualbasic.net not vba? Please Help

Hello Community, I was wondering if there is a way to replace a cell value from one excel spreadsheet and save it as another spreadsheet but with the replaced cell value. Please Help

I've inherited a small C# command line program that takes a date and creates several spreadsheets containing data pulled from a microsoft sql server database based on that supplied date and some names hard coded into the program. I'm looking to change the program to pull the data from a …

I would to add row values in an array each column will be an array value. echo '<table>' . "\n"; for ($row = 1; $row <= $highestRow; ++$row) { echo '<tr>' . "\n"; for ($col = 0; $col <= $highestColumnIndex; ++$col) { $values = '<td>' . $objWorksheet->getCellByColumnAndRow($col, $row)->getValue() . '</td>' …

I would like to add data from 2 worksheets in the same document and have them combined in one worksheet. Am using PHPExcel could you guys kindly help. -worksheet 1 and worksheet 2 = worksheet 3(combined worksheet1+worksheet2) Thanks

im making a student marksheet generation project.....and i need a facility to print from turbo c++ to excel.... i have used only file handling and no database(tht was the criteria). pls help.....

I want 1 dialog box which is having a login username and Password field. ANd it must have 12 buttons. whenever i click on any button, it must open 1 Excel sheet associated with it. Just want 1 skeleton code.

The cell values in excel are all formatted as text. Each value in the source array is not a String but to a proper data type based upon its value but I want the cell formatted value as it would appear on the screen in excel. Some of the cells …

I am trying to open an instance of Excel 2007 and load some text into a new file's cells (such as a list of something) through my Delphi4 program. I have already tried the ShellExecute and ComObj (variant) methods. ShellExecute works fine on the Windows XP platform, but not on …

I wasn't quite sure where to post this so I thought considering SSRS in VS 2005 produces XML scripts i thought this would be the best forum. I have a table grouping which produces a number of tables using the same section of xml code. Due to this the problem …

Hi All,, I want to add new leave type which its respective purple color to the already existing template by microsoft office available at "http://office.microsoft.com/en-us/templates/results.aspx?qu=employee%20attendance&queryid=194963f8-3883-4599-b317-3dbd92b705c5#ai:TC102780235". Anyone could help me how to add new add new leave type and its color to the year column. Thanks in advance Jos

I want to make student management system in which student will enter his data and we can save it in any other program such as word, excel. And when he will open again he can get his data back..

Not sure if this can be done. There are word files in a directory with all familiar names. i.e. fr001, fr002, fr003, etc... all with the extension .doc. I would like to know is there a code that will link an excel file to a directory and then be able …

I could reallly use some help. I am a complete newbie in python. What I would like to do is import a csv file (originally an excel file). Have the user pick a beginning month and an ending month and add the columns of the months between. For example I …

hallo there i read an excel file using excel_reader library. The excel file contains greek characters. i get the data and store it into arrays (it is a common xls file that contains names, lastnames and fathersnames) using characters set utf-8. the code works fine //i uploaded the xls file …

Dear C++ Gurus/Experts, I am writing a program to automate excel.My program is working well when I use integer (Write/Read) in excel.My program also works well when I use string.But the issue appears when I use array of strings.I am getting the issue as below **"error C2664: 'SysAllocString' : cannot …

Hi! I have a php code that generates an excel file that is populated with mysql data of course through a mysql_query.. Here it is.. <?php require("aacfs.php"); header("Content-type: application/ms-excel"); header("Content-Disposition: attachment; filename=Reservation Summary_sortbydate.xls"); header("Pragma: no-cache"); header("Expires: 0"); $head1="Ayala Aviation Corporation"; $head2="RESERVATION SUMMARY"; $head3="For the period ___________"; $heads="$head1\n$head2\n$head3\n"; $query = "select …