[excel] Forum Topics

I am importing data from an excel worksheet in to a sql table, one of the columns in the table is set to nvarchar(50), the data i am importing are barcodes, but the problem i am having is the column is changing the data for example the number "5900397732209" is …

guys - most of the export to excel code i've found really doesn't wind up being excel. it's simply HTML w/ a .xls tag on it. and i've done this for years in asp.net, winforms in both c# & vb.net. but it's always a hack. can someone point me in …

Hi this is Sukhdev, I am new in php and wish to know how to import the data from excel sheet to mysql Table; 1. I have a table with the name of city in mysql with following fields; city_id,city_name,tier_id,tier_name,state_id,state_name 2. what would be the function for uploading above fields, …

Guys I need your help again I use this code to copy values from excel spreadsheet to datagrid. Try 's = Clipboard.GetText() Dim tArr() As String Dim arT() As String Dim i, ii As Integer Dim c, cc, r As Integer tArr = Clipboard.GetText().Split(Environment.NewLine) r = Form1.DataGridView1.SelectedCells(0).RowIndex c = Form1.DataGridView1.SelectedCells(0).ColumnIndex …

Group, I've got a protected spreadsheet at work that prevents me from creating links or writing macro's to do some repetitive copying and pasting from one spreadsheet to another. I hope someone can help. I'd like to use VB (if possible) to copy from a specific range in Spreadsheet1.Sheet1 (let's …

I import a spreadsheet (csv) into my sqli database (keeps a track of all our firewalls) there are 10 excel columns , one for each connected network on the firewall. i would like all these columns to be imported as one entry in the database, so 1 database field would …

i want the whole excel file has to open in web page n moreover have to enter some input and will hv to **insert/update** based on formulae cells. Is thr any chance to achieve this?

Dear all, I have exists excel file on server. Now, I want output the file by php. I have this code: $file = "test.xls"; $file=basename($file); if (file_exists($file)) { header('Content-Type: application/ms-excel'); header('Content-Disposition: attachment; filename='.$file); ob_clean(); flush(); readfile($file); exit; } When I click download button, I can open file, but appear "missing …

I am trying to do a Page to PHPExcel to user fill an Html Page and send to PHP and it will: Open my default Excel Page and after fills the Excel Page with information send by Html What i dont know is how to do it read if is …

I have a button which make it add data to accees database,but i want to another button which will make export data from access to excel. here is my button : try { string cmdText = "Insert INTO data(Name,Mail) Values(?,?)"; db_conn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\Alpozkanm\\Documents\\Visual Studio 2012\\WebSites\\IntegratedSubscribeSystem\\veri.accdb;Persist Security Info=False;"); OleDbCommand …

<?php include ('pages/dbconnect.php'); $rekdep=mysql_query("SELECT * FROM t_org ORDER BY dept, com ASC"); echo "<table class='gridtable'>"; echo "<tr><tr><th> Departement</th><th> Commune </th><th> ORG </th><th>Animal</th>"; echo "</tr>"; echo "</tr>"; $odl_dept = null; $odl_com = null; $odl_org = null; while($dep=mysql_fetch_assoc($rekdep)){ //List of department if($dep['dept']!=$odl_dept){ echo "<td>".$dep['dept']."</td>"; } //display blank td if the same department …

good evening people,i'm creating an application where i'd like to import and save a list of people in an excel sheet to my database in mysql, using php, And i'd like to modify it through a form using php! Can anyone have an idea or something which will help me …

More and more guys are using the TAB for its features like email, phone,camera, small office like PP word excel. How is it really different from a cell phone? Is it going to replace the LAPTOP?

I have a column in a spreadsheet labled SEX with the value of 1 or 2 for male or female. How do I calculate the average number of males and females? Or should I use a different value to calculate??

Can i help U ? Need to get information into the Order .

Hi.. I really don't know what to do with my Program, it is needed to have a excel file on MDI Form, But i really don't how to. Can somebody help! Highly Appreciated. : ) Thanks! :)

pls help me i need this code to view my excel data in vb6 forms only.

If your Excel spreadsheet is laid out as regular columns and rows with a header row that identifies the columns then this code will allow you to read the data using ADODB the same way you would read records from a database table. To try this code 1. Create a …

I really didn't know where to post something like this so sorry guys if this not the right section I have a text file looks like this   I want to import it into Excel file so each info will be in seperated coloumn , even the …

Hello I am using jxls quite fine. I'm sort of on my last lap with exporting my data to a file. However all I want to know is, how do I display my collection in the same row please? I've manage to do this downwards in the same column, but …

hi! i am creating a program that need to import excel file. i really don't know how to. Can someone help? Thanks in Advance! God Bless!

I have an Excel spreadsheet that contains names. addresses and various other information. I have word wrap set for all cells in case some new data gets entered that's long. If I sort the data, the data that was in the cells that were word wrapped will end up in …

Hi, I have a VBA script that places WinForm dropdown boxes (xlDropDown) into an excel workbook dynamically. For some reason, on the 17th box (called "INCL" & i + 1 in the code below), the data type of the placed shape becomes msoAutoShape instead of msoFormControl. All of the following …

# i get the excel values, but i dont separate the column value, how to i get the columns value. # include 'simplexlsx.class.php'; $xlsx = new SimpleXLSX('bb.xlsx'); list($num_cols, $num_rows) = $xlsx->dimension(2); foreach ($xlsx->rows(2) as $key => $r) { echo $key . "<br>" . $r; }

How can i copy data from a named range in a different worksheet and paste it to another worksheet all done without activating both sheet. With all code just behind a form button If i try to use the statement **application.goto reference:="x"** where x is the named range but this …

Hi, I need to create a page where an admin can upload an excel worksheet in the .xlsx file format, this is then read and writen onto another php page. I'm new to PHP so I am confused by the code, I can find help on .xls but not accepting …

This may require an expert in MS Excel, I happen to have version 2007. The issue involves how Excel is distorting images when placed in a sheet. Imagine this scenario, and maybe duplicate it on your end: 1) I use the graphic borders feature of MS Word to create a …

Sheet1 A1: Football A2: Rugby A3: Basketball Sheet2: A1: A2 A2: B4 How can I get a location of a field from String? Is it even possible? *eg. I want to tell the contents of cell A2 in Sheet1 by getting the string value "A2" from cell ''Sheet2'!A1'*

Hi Experts my excel data is copied successfully to the listview. But on importing to database, I get this error. InvalidArgument=Value of '5' is not valid for 'index' ParameterName:Index ================= I have 2 problems ================= Problem 1: What should be the problem when I importing from listview(I think it is …

Sorry in advance if this is the wrong place for this, it's the closest I could find. I need to create a macro for an Excel 2010 spreadsheet so that the active cell will cycle through three choices: "Y", "N" or "" - the last being simply an empty string …