Search Results

Search found 6232 results on 250 pages for 'excel 2013'.

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

• Excel Date to String conversion

  - by Chaitanya MSV

  Hi I have a Date value like 01/01/2010 14:30:00 in a cell in Excel sheet. I want to convert that Date to Text and also want the Text to look exactly like Date. So a Date value of 01/01/2010 14:30:00 should look like 01/01/2010 14:30:00 but internally it should be Text. How can I do that in Excel? Thank you! Chaitanya

  Read the article

• Writing Text data File using C# to excel

  - by Joe

  Hello, New at C# using visual studio 2008 and trying to load an excel sheet with a text file. My current program puts the complete file in one cell. Is there a way to put each data point in its own cell. Having issues interfacing with excel to accomplish this task. Thanks Joe

  Read the article

• Import excel files with image in php/mysql

  - by Marcel

  Hi all! I want to make an import script which allows users to upload their excel file (extension not important) to my php application. The application should reconize a list of items (so far so good). The difficulty in this case is that the excel files contain images...I've read information about phpexcel library but it does not say anything about images. Anybody ideas? Regards, Marcel

  Read the article

• Javascript Chart to Excel

  - by George

  Hi I'm using highcharts to create some charts (pie, bar, etc...) using just Javascript. These charts do not use Flash or anything like that. Is it possible for me to convert the resulting HTML page with the Javascript chart to an excel document that properly shows the image? I've tried the standard change mime types for excel and so far I've only been able to export an HTML table on the page, but no chart.

  Read the article

• Populate a value in MS Excel

  - by acadia

  Hello, I have a Excel spreadsheet and I have 3 columns. column A, column B, Column C. In column B if there is a value 1 then in Column C it should populate as True and if in column B value is 0 then in C it should be False. How do I do this in MS Excel

  Read the article

• Excel Automation

  - by sltsta

  Hi All, Does everyone know how to create custom button in the excel that display simple window form in csharp language? For example: A button called "Show" in the excel toolbar that show messagebox pop up.

  Read the article

• excel - inserting data with OleDb c#

  - by Cmptrb

  Hi, my code is below: private string connectionstring = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\myexcel.xls; Extended Properties=""Excel 8.0;HDR=YES;"""; this is my connection string, the excel file is created writable (not readonly) either my command to insert any data is : string commandstring = "insert into [mus$] (name, surname) values('mickey', 'mouse')"; But my commandstring does not work and gives the error: "number of query values and destination fields are not the same" Where I do mistake ?

  Read the article

• How to detect the language of MS Excel.

  - by Radoslav Hristov

  Hi guys, I'm trying the figure out a way of detecting the language of an installed version of Excel (ideally from C++). I need this to resolve an issue with computers on which the language of Excel differs from the Windows language (see this problem).

  Read the article

• Problems of reading Excel 2003 using Oledb

  - by Tim

  I tried to use Oledb to open Excel 2003. Looks like I can read most of data, but for some cells (such as number), the value returned is Null. Any suggestion? My connection string: ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;"

  Read the article

• Retrieve pictures from Excel file using OLEDB and C#

  - by CBoy

  I have an Excel sheet with two column, one is a number , and second column have a picture. i want to read these data from c# with oledb connection, i can read number easily , but pictures is not contained in second column , so in c# i just get first column. now, how can i read the images ? i want to extract the numbers and related images from this excel sheet. Thanks.

  Read the article

• Learning Excel with a book

  - by Teifion

  I work at a company where all the TMs and assistant TMs use Excel for number management, we're not able to use anything else because the computers are locked down (for good reason though I'll be asking IT anyway). The company also has a buy-a-book scheme, can anybody recommend a good book for using Excel and Macros in it?

  Read the article

• How to create-edit-remove excel files?

  - by Giuseppe

  i am doing a project that has some simple values(login,password,name,age). I was searching on the internet how to create an excel file on Visual C++, and i cant undestand it . I just want the simple way, i just want to see on my excel files 2 colums one having some login codes of my program and on the other the passwords. My programing level its not really high and im not an english speaker, so id like you guys to explain a bit or give me something simple. Thanks for your time

  Read the article

• How to switch from MSSQL to MySQL for using with Excel pivot

  - by Sim

  Hi all, I have a table that contains sales transaction (~20 mil rows). Previously I used MSSQL and export it to an Excel pivot. Data refresh took 10-15 minutes but still do-able. However, after I migrated to MySQL (using XamppLite & ODBC), it took forever to refresh the data in the Excel pivot. Maybe I didn't optimize the MySQL good enough ? Anyone can share some thoughts 'bout this ? Thanks

  Read the article

• Problem with Refreshing entire excel workbook

  - by Nimo

  Hi, I'm trying to refresh a entire excel workbook using Application.CalculateFull function. However, I found that, the sheet does not get not updated ALL the time (sometimes it do). A random number of functions only get updated at sometimes. I'm using excel 2007, please tell me what's going on with Application.CalculateFull function. Thank you

  Read the article

• update SQl table from values in excel

  - by user175084

  I am using the SQL Developer or SQl express. How do i get the values from an excel sheet and update those in a column of my database... Please help thanks. i have this and im running it but i get error: SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\books.xls', 'SELECT * FROM [Sheet1$]') i get error now OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Could not find installable ISAM.". thanks

  Read the article

• Tamper Proof Excel Document using java

  - by Captain Crunch

  How to create tamper proof Excel document using java? Now i am using Apache POI package for generating Excel documents. Help Me Bravos ....

  Read the article

• excel turning my numbers to floats

  - by femi

  Hello, i have a bit of asp.net code that exports data in a datagrid into excel but i noticed that it messes up a particular field when exporting. eg .. i have the value of something like 89234010000725515875 in a column in the datagrid but when exported, it turns it into 89234+19. Is there any excel formatting that will bring back my original number? thanks

  Read the article

• Need to place a floating modeless form over excel main window (quasi-task pane)

  - by code4life

  Hi I need to emulate a task pane by floating a modeless form over the Excel main window. The reason for this requirement is that I need to have taskpane features for my Excel 2003 add-in, but cannot use the document-centric model. Can anyone suggest what would be the best way to do this? The modeless form would need to detect the main window resize event and resize itself accordingly, and also need to always position itself at the bottom of the window (kind of like a docking pane).

  Read the article

• Reading Excel files from C#

  - by dbkk

  Is there a free or open source library to read Excel files (.xls) directly from a C# program? It does not need to be too fancy, just to select a worksheet and read the data as strings. So far, I've been using Export to Unicode text function of Excel, and parsing the resulting (tab-delimited) file, but I'd like to eliminate the manual step.

  Read the article

• Data files from EXCEL for MySQL

  - by Alex

  Hello to everybody, I was trying to output Excel's data to a text file to use them in MySQL, nevertheless i was not able to find an easy solutio because at the end of each row I have to add manually a "TAB" ! Otherwise there are always errors in the MySQL table, is there any special data format to export these data from Excel 2003 ? Thanx for your help Alex

  Read the article

• Possible to send message to excel userfom control

  - by jedd

  As I understand it, excel userform controls are windowless (at least majority of them). Due to this fact, would it be possible to update an excel userform using win32 ?

  Read the article

• What is correct content-type for excel files?

  - by taw

  I want excel files on a website to open in Excel when clicked, not get saved on desktop, or get opened embedded in a browser etc. Now obviously it all depends on how everything is configured for each user, but what's the best Content-Type and other settings to achieve just that most of the time?

  Read the article

• Exporting from SSRS to Excel with no headers

  - by alram

  Is there a way to export to excel from an SSRS report so that the header that displays on the first page of the report is omitted only in the excel export? Currently, it adds a frozen frame to the top of the worksheet.

  Read the article

• How to get javascript's variables by excel vba?

  - by cpps

  assume that I have a html file in which javascript like this <script type="text/javascript"> var test1 = 1; var test2 = 2; var tset3 = 3; </script> So, how can I get javascript variables by excel vba and use it in excel vba?

  Read the article

• How to Implement Excel COMBIN function in SQL

  - by Umar Siddique

  How can i implement Excel COMBIN function in SQL 2005, either in a store procedure or in a function. About COMBIN function in Excel follow this Link. Thanks.

  Read the article

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