Search Results

Search found 18321 results on 733 pages for 'excel library'.

Page 60/733 | < Previous Page | 56 57 58 59 60 61 62 63 64 65 66 67  | Next Page >

• Problem with reading excel cell value to a VARIANT

  - by Nimo

  hi, I'm reading a excel cell value to a VARIANT data type from VBA code. When I enter a integer value to the cell, the VARIANT always takes the argument as type double. Please help me to rectify this problem. Thank you

  Read the article

• ms-excel: bubble trouble - creating amazing looking charts [closed]

  - by every_answer_gets_a_point

  i am reading this article: http://www.juiceanalytics.com/writing/bubble-trouble/ i would like to make a chart that looks like this in excel. is vba a requirement? can anyone help me to start?

  Read the article

• 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....

  Read the article

• 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 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, thlaing

  Read 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 key

  Read 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 you

  Read 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 cell.Value = "Capa" Then ActiveCell.Offset.FormulaR1C1 = "=HEX2DEC(R[2]C[-1])" End If Next cell Thanks!

  Read the article

• How to copy Excel data into Textbox control

  - by sukumar

  How to copy Excel data into a Textbox using C#? Please provide me the code for the same.

  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 want to test against are in a Listbox.

  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 an alternate solution.

  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 behaviour?

  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 variable as string, text, object and variant already and it's not working. Do you know what code should I use to be able to do this?

  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 and straightforward as possible.

  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 myself).

  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

• 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 = Application.WorksheetFunction.Sum(rExternalTotal) dExternalTotal is always zero. I cannot delete the blank spaces on the work sheet. Can anyone suggest a way to do the sum programatically?

  Read the article

• Export value from Excel worksheet to Access record

  - by glinch

  Hi there, I have an excel spreadsheet that contains the primarky-key/id value for a record in a table in an access database. I would like to export specific data from certain cells in the spreadsheet to certain fields in the corresponding record in the table. Is this possible, any help would be greatly appreciated. Many thanks Noel

  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? Thanks

  Read the article

• Reading a Excel 2007 Spreadsheet in C#

  - by paradox

  I've done some googling and there seems to be a plethora of tools for reading excel 2007 spreadsheets using c#. I'd like to know which one performs best and is easy to use.

  Read the article

< Previous Page | 56 57 58 59 60 61 62 63 64 65 66 67  | Next Page >