Search Results

Search found 10345 results on 414 pages for 'ms excel'.

Page 63/414 | < Previous Page | 59 60 61 62 63 64 65 66 67 68 69 70  | Next Page >

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• Excel worksheet in Webbrowser component using c#.

  - by Rabin

  I have loaded an Excel worksheet inside a WebBrowser component. Now I need to do some calculation and insert the result of the calculation into a named cell in the active worksheet. Could someone please help me with this. Thank you.

  Read the article

• How to keep format within HTML converted to Excel

  - by pojomx

  Hello, I'm working with an HTML table, that contains numbers (formated) and when I export this to xls file (just change extension... hehe) I loss some of the formated data. Example: in html I have " 1,000.00 | 500.00 | 20.00 " and in excel it shows like: "1,000.00 | 500 | 20" I want it to know if it is possible to show the very same format as in html. THankyou :P

  Read the article

• need to replace an image inside word-document with an excel chart

  - by anseal

  is there any simple way to replace an image inside word-document with an excel chart using VB and preserving all of the format details such as image frame style, text wrap, anchor, etc. (thus the image is just a placeholder in a template document)

  Read the article

• Excel Merge() vs MergeCells

  - by sleepp

  Hi, I'm using VSTO, C#, and Excel but VBA probably applies here as well. What's the difference between calling the Merge(missing) method on a range and setting the MergeCells property to true? Does Merge() fail more often? Thanks!

  Read the article

• Export Gridview with image to Excel - Problem

  - by Arny

  I have a Gridview in my ASP.NET C# Page. It has a couple of columns and also one image column. I can export the entire columns to an Excel file, but the image column is blank. By the way, I use the full path. Any Idea?

  Read the article

• Can you connect to sql server from Excel?

  - by AnonymousCow

  Hi, I need to create some reports from a sql server database for end users to view. Is it possible to hook into sql server from excel? Update The end user will only click on the file to view the reports, asking them to do more is too much to ask!

  Read the article

• Reading Excel file with C# - Choose sheet

  - by Dänu

  Hey Guys I'm reading an excel file with C# and OleDB (12.0). There I have to specify the select statement with the name of the sheet I wish to read ([Sheet1$]). this.dataAdapter = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", connectionString); Is it possible to select the first sheet, no matter what name? Thank you.

  Read the article

• List of objects to Excel Spreadsheet?

  - by Max Fraser

  Anyone know of some code out there that does this already? I have a bunch of pages with data grids on them in an admin website they want to export them to Excel, was hoping someone had this written already - or if not I'll post mine when I am done.

  Read the article

• Adding Date to Excel using Open XML

  - by Ant

  Hi, I would like to insert Date value to excel file using Open XML. Here is my code sample. cell.CellValue = new CellValue(value.ToString()); cell.DataType = new EnumValue<CellValues>(CellValues.Date);

  Read the article

• Updating data source on multiple pivot tables within Excel

  - by phrenetic

  Is there an easy way to update the data source for multiple pivot tables on a single Excel sheet at the same time? All of the pivot tables reference the same named range, but I need to create a second worksheet that has the same pivot tables, but accessing a different named range. Ideally I would like to be able to do some kind of search and replace operation (like you can do on formulae), rather than updating each individual pivot table by hand. Any suggestions?

  Read the article

• Import excel file into sql express 2008

  - by ck

  Hi, I've got some excel files, that were exported from tables in Access, and I want to import them into sql express 2005. I need a script that will convert nvarchar(255) columns to varchar(255) and preserve links, when importing the data into sql express. Thanks

  Read the article

• Cell color changing In Excel using C#

  - by Suryakavitha

  hi, I am using windows application for export data table to Excel...its working.. Now i want to give some color for particular text in the cell... How shall i do this? Anyone tell me the solution of this... Thanks in advance...

  Read the article

< Previous Page | 59 60 61 62 63 64 65 66 67 68 69 70  | Next Page >