Search Results

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

Page 58/192 | < Previous Page | 54 55 56 57 58 59 60 61 62 63 64 65  | Next Page >

• 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

• 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

• 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

• 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

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

• Free library to generate excel chart in .NET

  - by SchmerZ

  Hi to all. I need a free library (or not too expensive) for .NET to work with the excel document. I need to read data, modify, save and add charts into the document. Or in another way, I need a free library for creating and inserting charts into the excel document (only for charts). I have found FlexCel and SmartXLS, but FlexCel doesn't support the charts (can't create), while SmartXLS has a small functionality. Thanks for any help.

  Read the article

• How do I convert a datatable to Excel sheets in windows forms using c#

  - by cmrhema

  Hi, I am working on Windows Forms application , c# I have three datatables. I want to save the first table in Sheet1 of an excel , second table in Sheet2 of the same excel and the third in the Sheet3. The names of these three sheets will remain the same, as Summary,Details and Retailers. Can anyone please let me know how do I do this. Regards Hema

  Read the article

• Excel 2007 Format Row of Cells containing certain text

  - by paradox

  I am attempting to perform conditional formatting in Excel 2007 by checking if a cell has a specific string in it and therefore highlighting the entire row corresponding to the text. However, Excel 2007's Conditional Formatting only allows me to highlight that specific cell. Is there a workaround to this without having to get my hands dirty with VBA?

  Read the article

• Insert Image on Excel using Open XML

  - by Pankaj

  Hello All I am using this toolkit to write Excel.Every thing is fine with this, but i am not getting how can i inset image and also put style on some rows on my excel http://excelpackage.codeplex.com/wikipage?title=Creating%20an%20Excel%20spreadsheet%20from%20scratch&referringTitle=Home i am using c#

  Read the article

• Formatting a CSV File that contains HTML for Import to Excel

  - by Dave

  I would like to export a CSV file from my application for importing into Excel (or any other spreadsheet that supports CSV files). Anyhow, one of the cells in my table have rich content (i.e. HTML) which can, of course, contain commas as well as other HTML characters and formatting. I realize that Excel "can" handle HTML formatted text, but exporting it as CSV tends to screw up the data for importing. Is there some particular way I can format that particular cell so that imports correctly?

  Read the article

• How to formatting Excel Sheet cells using PHP

  - by PHP-Prabhu

  Hi all, Please help me about my doubts on excel and php. I need to do the following process on excel report generation using php to change cell's font styles to change cell's BG color to change cell's width

  Read the article

• find a Stationary points Excel

  - by uv

  Hi, I am looking for a funcation in excel that will show my the Stationary points in th table. for exapmle A point is the lowest point on the table B point is the highest point - after point A C point is lowest point -after point B on the X there are point A,B and C, on the Y there are dates . I hope it is clear - i diddn't find the way to add the excel. Many thanks in advnce Uv

  Read the article

• Copy List of Structures to Excel Range

  - by KDP

  Does anyone know how to copy a VB.Net list of structures to an Excel range? It's not hard to do with an array, but I can't get a list of structures to work. Example: Structure MyStruct Dim MyField1 as String Dim MyField2 as Integer End Structure Dim MyList As New List(Of MyStruct) ...populate list of structures... Dim rng as Excel.Range = MySheet.Range("A1","B9") rng.??? = MyList '*** This is where I get stuck. ***

  Read the article

• Inserting and updating data in Excel

  - by user303907

  Hello, So far all the Excel stuff revolves around opening a file, writing values to it and saving it. Is there a way to update the data in the Excel (while it's opened) automatically? Thanks!

  Read the article

• check inserted value in excel?

  - by Rev

  Hi I wanna check inserted value in excel cell and if value is higher than something(for example 3000) excel don't accept value(also throw error). So how can I do this?

  Read the article

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