Search Results

Search found 67192 results on 2688 pages for 'excel external data'.

Page 84/2688 | < Previous Page | 80 81 82 83 84 85 86 87 88 89 90 91  | Next Page >

• 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

• 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

• 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

• 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

• 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

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

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

  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

• 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 invalid or green if valid. Again there only options are in a List box. Any help would be awesome. Thanks

  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

• Find more than one string with Excel?

  - by TaintedLove

  How to Find more than one string with Excel with the graphical interface? For example, I am looking for the cells which is contained both strings Paul and John?

  Read the article

• Excel In Java Web Application

  - by Anand

  Hi I have a java web application running on windows currently. I may host it in future in a Linux Server. My application allows people to upload data. I want to display the data they have uploaded in an excel file and render it in a portion of my webpage. How do I go about this ?

  Read the article

• Identifying Different Excel File Formats

  - by sgibbons

  Is anyone familiar with a library or tool that can determine which format an excel file is in? Or, failing that, documentation on the different formats that would allow me to write my own?

  Read the article

• Excel embedded in a php page

  - by Brian

  I have a client who wants to be able to embed an Excel document (one that is currently sitting on the same server as the HTML document) like how you would embed a Flash app on a page. I'm correct in assuming this is not possible, right? Please confirm/deny so we can hopefully move on from this because he seems to think this is possible. We are on a LAMP setup so no .NET tricks, unfortunately.

  Read the article

• Excel : Increment Row number on fill right

  - by soldieraman

  When one "Fills right in excel" , the Column name updates eg. 1st cell is =A2 If I fill right the next cell will be =B2 But rather than the column incrementing I want to increment the row number so 1st cell is =A2 The cell on its right is =A3 how do i do that?

  Read the article

• excel automation edit existing chart

  - by user330737

  Hi Everyone, I need excel automation expert here. I have chart with x-axis contains label: Jan,Feb,Mar,Apr and y-axis contains label: 10,20,30,40. Chart type is Bar. Can anyone show me a csharp code how to change to Bar color to different color if the month is Mar? I hope you guy understand my question since I can't put the image on stackoverflow. thank you

  Read the article

• How to Validate Pasted Dates in Excel

  - by jimdrang

  I want to validate pasted dates to remove /'s and ensure the year is 4 digits and when users paste them in it overwrites my excel validation. So, If a user pastes 05/19/10 into a cell, I would like it to convert to 05192010 or at least give an error if this is not possible. I don't know enough VB to add sheet-wide code that does this and I'm not sure if it would work when users paste multiple cells at a time.

  Read the article

• Export Excel in ruby on rails

  - by Small Wolf

  Hey guys! I want to export the page Info to Excel ,who can tell me how can i do this? thank you!

  Read the article

• Import numbers from an excel column using C#.

  - by LIX

  Hi. I have an Excel file with one column which is filled with numbers. I would like to be read the numbers from this column into an array in C#. How can I do that? Thank you all.

  Read the article

• Read/Write Excel Files Directly To/From Memory

  - by Corey O.

  Several people have asked, in a roundabout way, but I have yet to see a workable solution. Is there any way to open an excel file from directly memory (like a byte[]) ? Likewise is there a way to write a file directly to memory? I am looking for solutions that will not involve the hard disk or juggling temporary files. Thanks in advance for any suggestions.

  Read the article

• Mapping between Excel and XML file - How to refresh from C#

  - by osteinme

  Hi Got an excel spread sheet where I specify mapping to an XML file. I'd like to open the spread sheet from C# and force refresh the cells mappped to the XML file. - How can I do that ? Any dll I need to reference ? Thanks Olivier

  Read the article

• FTP a text file to a server using VBA in Excel

  - by Anindya

  I have an Excel worksheet where the user enters certain data, which I want to store in a text file and upload to a server using FTP. One site suggested adding a reference to "Microsoft Internet Transfer Control" and then define an "Inet" object to do the FTP. However, I am unable to find a reference with this name in "Tools - References" in the VB Editor. Does anyone know of a solution for this problem? Thanks in advance.

  Read the article

• Column No to Column Letter in Excel/VSTO using C#

  - by sukumar

  How to find column's name or header? For example if i select column 5 in excel means i want the result as "E". How to get the alphabet or letter corresponding to column no. Please help me with the code

  Read the article

• how to insert a jpeg image into an excel sheet

  - by Shiny

  Im able to generate tables with all required columns and with datas in excel sheet. now i want to insert image that is present in my bin.how can i achieve this. thanks in advance

  Read the article

• Import Excel spreadsheet columns into SQL Server database

  - by roy0911

  I have an excel spreadsheet that I want to import select columns into my database table. the wiz didn't offer that option. any easy code options? Thanks newbie

  Read the article

< Previous Page | 80 81 82 83 84 85 86 87 88 89 90 91  | Next Page >