Search Results

Search found 4783 results on 192 pages for 'excel vba'.

Page 71/192 | < Previous Page | 67 68 69 70 71 72 73 74 75 76 77 78  | Next Page >

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• MS Excel connection with vb.net

  - by Noreen

  I have used the connection string below but I am getting an error when trying to create a table Dim ConnString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & strFName + _ ";Extended Properties=""Excel 12.0 Xml;HDR=YES;IMEX=1""" Cannot modify the design of table 'tablename'. It is in a read-only database.

  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

• 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

• 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

< Previous Page | 67 68 69 70 71 72 73 74 75 76 77 78  | Next Page >