import excel data to gridview C#
- by Royson
hi... i need the code for import excel data to gridview in windows forms application... Plz anyone can tell me that code....
Search Results
Search found 7708 results on 309 pages for 'excel 2007'.
Page 112/309 | < Previous Page | 108 109 110 111 112 113 114 115 116 117 118 119 | Next Page >
-
-
load excel data in c#
- by LIX
Hi; I have an Excel file with one culumn and there is a lot of numbers in it. I want to want these data to an array in c#. I want c# code immediately. Thank you all...Read the article
-
How do I delete a signature from an Excel document using Office automation
- by Guy Marom
Hello, I have a signed Excel workbook and I want to delete the signature from it. The problem is that when I try to delete the signature there's a prompt for confirming the deletion and I want the process to be fully automatic. Here's a code sample, the prompt appears when the last line executes: Dim source As String = "c:\temp\signed.xlsx" Dim…Read the article
-
How to read Excel cell from VB.Net
- by RedsDevils
How can I read specific cell from Excel file using OLEDB Connection with VB.NET? Can you show me sample solyion? Thanks inadvance! Best reagrds, thlaingRead the article
-
how can I call the chart in excel using poi
- by Zen
i have an excel template and there was a chart there, I was confuse on how can I call that chart when I'm coding.. Can anyone help me on how can I call the chart for me to set the new value to fill the chart..Read the article
-
Excel: TableAdapter UpdateCommand for table without primary key
- by Steven
What is the syntax for an Update query / UpdateCommand for a table from an Excel Data Source (therefore having no a primary key)? Note: Similar to: MS-Access: TableAdapter UpdateCommand for table without primary keyRead the article
-
Export data as Excel file from ASP.NET
- by Yongwei Xing
Hi all I have data like below AAAAAA BBBBBB CCCCCC DDDDDD EEEEEE Now there is button on the page,when I click the button, the browser would download a excel file with the data above, and stay current page. Is there any simple way to do it? The data is very simple. only one column, and not huge. Best Regards,Read the article
-
iPhone Excel generation
- by satyam
I'm creating an application that generates purchase order. I'm able to create text file from the details entered by user. I would like to generate an Excel which looks much better than a normal text file. Is there any open source library that I can use in my application?Read the article
-
Export object to excel using C#
- by developer
Hi All, What is the best way to export objet to excel file in C# (.net framework 3.5)? Thanks in advance!Read the article
-
How to wrap images into a Excel Add-in 2003
- by nimo
hi, I'm having a excel add-in with several menu items. Each menu item embedded with a image. I'm loading picture to menu item using LoadPicture function where I gave the absolute path to image location. In order to make the add-in distributable I need to provide a relative path. Appropriate anyone can suggest me how to do this. Thank youRead the article
-
How to run an equation along whole column in excel vba
- by Elad Sommer
I want to run an excel vba which will go down column E and upon finding the value = "capa" will go two cell below, calculate the hex2dec value of that cell, present it by the cell with the value "capa" in column F and continue to search down column E. So far I've came with the below but it doesn't work: For Each cell In Range("E:E") If…Read the article
-
Password Protected Excel File
- by dhorn
I have an excel spreadsheet that is password-protected. I need to open this spreadsheet and read the data from it. I've been attempting to use the POI API to no avail. A Java solution would be preferred but any ideas would be helpful. Edit: Yes, I have the password. Edit2: I am unable to open it with POI with the password, I am looking for…Read the article
-
Conditional Formatting in Excel
- by littlevahn
I'm very new to Excel and VBA and was wondering if there is a way I could make conditional formatting based on values in a drop down list. I currently have a warning if the user enters something that is not valid (data validation), but I want to change the cell's background color to red if invalid, or green if valid. Again the options I…Read the article
-
OleDB Jet - Float issues in reading excel data
- by Patrick
When I read a sheet into a DataTable using the OleDbDataReader, floating point numbers loose their precision. I tried forcing OleDb to read the excel data as string, but although the data is now contained in a DataRow with each Column defined as System.String it looses precision (18.125 - 18.124962832). Any idea how to avoid this…Read the article
-
Printer setup via VBA in Excel
- by Gina
I am trying to assign a cell in Excel for the user to type the printer name where they want the print out to go and then use that value in the Application.ActivePrinter = (use the cell value) Even though I have done the programming assigning a name to the cell and using it in a variable it is giving me an error. I have set my…Read the article
-
Generating an Excel file in ASP.NET
- by Dan Coates
I am about to add a section to an ASP.NET app (VB.NET codebehind) that will allow a user to get data returned to them as an Excel file, which I will generate based on database data. While there are several ways of doing this, each has its own drawbacks. How would you return the data? I'm looking for something that's as clean…Read the article
-
Excel/SQLite date serial numbers
- by John Smith
How can I get SQLite to accept excel-type serial number dates, e.g. I want to put the integer 40074 in a table and somehow get the date 18 Sept 2009?Read the article
-
How do I export charts from Excel as graphics
- by user83266
I've got a series of Excel spreadsheets, each with at least one page of data and one page of a chart created from the data. I need to capture ( not regenerate from the data ) the existing chart as a web friendly image. Is this possible via Java or .Net? I know the POI stuff (Java) won't do it (or so I'm told, haven't tried it…Read the article
-
Assign multiple lines in single cell in excel using C#
- by Suryakavitha
Hi, i am using windows application and i export datatable into excel sheet... it will display successfully ... now i want to give multiple lines i a single cell... how shall i do this by using C#? Anyone tell me the solution of this.. Thanks in advance....Read the article
-
Extracting the hyperlink value from an excel cell using asp.net
- by beytz
Hi, I'm reading an excel file using oledb in my asp.net code (vb). I have no problem going over the data but in one of the cells there is a string that "hides" a hyperlink. I want that hyperlink and not the string... Any ideas? ThanksRead the article
-
Excel VBA - Sum up a column
- by kojof
Hi, I'm trying to sum up a column in Excel VBA , however because there are blank spaces, I'm getting 0 as the sum. Dim rExternalTotal As Range , dExternalTotal as Double Set rExternalTotal = Range(rReportData.Offset(0, 0), rReportData.Offset(261, 0).End(xlUp)) dExternalTotal =…Read the article
-
import data from excel in php
- by air
i want to import data from excel file using php. and then if possible to save it mysql database. ThanksRead the article
-
How to paste formula from visual basic to excel In relative
- by magh
In visual basic code works as below MyWorksheet.Range("A1:D1").Formula = "A1B2" In excel it shows in A1 as A1B2 B1 as A1B2 C1 as A1B2 D1 as A1B2 what i want do A1 as A1B2 B1 as A1B3 C1 as A2B4 D1 as A2B5 Thanks in AdvanceRead the article
-
Conditional Formating in Excel
- by littlevahn
HI, Im very new to Excel and VBA and was wondering I there is a way I could make conditional formatting on drop down Lists. I currently have a warning if the user enters something that is not valid (data validation) but I want to change the cell's background color to red if…Read the article
-
Finding contained bordered regions from Excel imports.
- by dmaruca
I am importing massive amounts of data from Excel that have various table layouts. I have good enough table detection routines and merge cell handling, but I am running into a problem when it comes to dealing with borders. Namely performance. The bordered regions in some of…Read the article
