Search Results

Search found 4437 results on 178 pages for 'excel udf'.

Page 40/178 | < Previous Page | 36 37 38 39 40 41 42 43 44 45 46 47  | Next Page >

• Write an excel workbook to a memory stream .NET

  - by Jon Cahill

  How do I write an excel workbook to a memory stream without first saving it to the file system? All options within the Microsoft.Office.Interop.Excel.WorkBook save options take a filename.

  Read the article

• Writing excel file to vb6

  - by Mark

  i have an excel file template and i want save the written value in textboxes to the cells of excel using vb6 language. can anyone help me?

  Read the article

• export to excel from vb.net from sql datareader

  - by reffer

  I have an sql query with sql datareader. i put a for loop for the data reader. now when the data starts coming in from the query i want it to export to excel in the for loop. here's my code Try Dim SqlStr As String = "", dr As SqlDataReader = Nothing ConnectDB(Cnn) Str = "query" SqlCmd = New SqlCommand(Str, Cnn) dr = SqlCmd.ExecuteReader while dr.read ..EXPORT TO EXCEL do end while does anyone know how to do this?

  Read the article

• Automatic hyperlink in Excel [closed]

  - by developer

  Hi All, Is it possible to hyperlink a url in excel automatically. I mean when the cell starts with something like http or www can I hyperlink that. Currently, I have to hit enter in the cell value in the formula bar to make the link as clickable. Also if I change the value in the cell, the link doesnt get refreshed until I hit enter. Is there a way in excel where it will automatically detect and apply a hyperlink.

  Read the article

• how to convert excel values into buckets

  - by oo

  i have a set of data in excel and in one column is a estimate (number of weeks) i want an excel formula to bucket it into Small Medium Large where if the value is 0 - 10 then put it Small. If the value is 10 - 20 put it in Medium, etc . . . if there any elegant way of doing it besides having nested if statements all put together?

  Read the article

• How to open Excel 2003 using .NET 3.5?

  - by Tim

  I'd like to open EXCEL 2003 from a .NET 3.5 application and manipulate each cell in the Excel sheet. Any one does that?

  Read the article

• MS Excel XML Header Footer

  - by Ravi

  Hello All, I'm generating a excel report in a XML Excel format. In this report I have to repeat the top 25 rows and bottom 10 rows on each page, like a header and a footer. Can you please guide me on the code that is required to accomplish this task. I'm using ColdFusion. Thank you. Ravi

  Read the article

• C#: Create/Insert Excel 2007 charts into Word 2007

  - by Partial

  How do you create and then insert an Excel 2007 chart in Word 2007 with office interoperability? Important: I do not want to save an Excel file to create a chart.

  Read the article

• Pros and Cons of automating Excel using VBA vs .Net

  - by Andy

  I've been tasked with creating a financial planning tool in Excel that would benefit from some custom functions/macros. My initial reaction was to use VBA. I've used it to drive Excel before (say 5 years ago). But I then began to wonder if I would be better off using VSTO. Has anyone has experience using both techs and can list the pros and cons so that I can evaluate which course would be best.

  Read the article

• Read excel 2007 file with OLEDB using a specific culture

  - by Derek Ekins

  I am trying to read an excel 2007 file (using OLEDB) that has dates in the UK format. The server is (sometimes) set to US format and so the normal date format problems are in play. This is my connection string: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=myfile.xlsx;Extended Properties="Excel 12.0 Xml;HDR=NO;IMEX=1" I want to ensure that the file is always opened using the en-GB culture. Is there a way to specify the culture using the connection string?

  Read the article

• Protecting Excel cell contents.

  - by Avinash

  How to protect Excel cells contents in Excel worksheet and also in its xml file format? I want cells to be read only.

  Read the article

• Excel Macro to create sheets

  - by Harish

  I have a Excel sheet with two columns and I need to create new sheets based on the values of the first column.ie A B test1 Value21 test1 Values22 test2 Value21 test2 Value32 test3 Values32 IN this case I need to create three sheets namely test1,test2 and test3 Sheet 1 should contain test1 field and its corresponding values.Similarly sheet 2 and 3 should contain corresponding values. Can anyone help me in writing an Excel Macro for this

  Read the article

• 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

< Previous Page | 36 37 38 39 40 41 42 43 44 45 46 47  | Next Page >