Search Results

Search found 7183 results on 288 pages for 'export to excel'.

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

• 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

• How to add an "Export to epub" feature to a site?

  - by systempuntoout

  How could i add to a blog or site in general a feature that let users export the content to epub format or some other open ebook formats? It's not a feature that i normally see on most of the site i browse every day (some has export to pdf that is not great as ebook format), do you think it is feasible?

  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

• 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

• 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

• 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

• How to export some data into .rtf or .doc?

  - by Narek

  Say I have created a GUI (Qt) that operates with some data(text+image). How I can export that data in one of listed formates in title. I guess it is better to export info .rtf as it is free cross-platform formt(??), isn't it?

  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

• 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

• PRINTER SET UP IN EXCEL VISUAL BASIC

  - 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

• Excel : sum of values depending of other values

  - by gregseth

  Hi, What would be the equivalent Excel formula of this SQL query SELECT SUM(a) FROM table WHERE b < 0; A B ---- ---- 1 0 2 -1 3 4 5 -3 >> 7

  Read the article

• Excel VBA SQL Data

  - by user307655

  Hi All, I have a small excel program. I would like to be able to use this program to update a SQL table. What would be the function to say update line 2 in SQL table Test in Database ABC Thanks

  Read the article

• Excel hyperlink

  - by developer

  Hi All, I have a column in excel, wherein I have all the website url values. My question is I want to turn the url values to active links. There are about 200 entries in that column with different urls in all cells. Is there a way I can create active hyperlinks to all the cells without writing a macro.

  Read the article

• Convert miliseconds to date (in Excel)

  - by Guy

  I have a row in excel with the following data: 1271664970687 (I think it's the number of milliseconds from 1970...). I would like to have adition row that will show it as date/time.

  Read the article

• Python library to validate Excel data

  - by Stan

  Is there any existing Python library that can validate data in Excel format? Or what kind of keyword should I use to search such an open source project? Thanks.

  Read the article

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