Hi, I am developing an application where i want i am displaying a dataset in the datagrid view for the user.Now the user wants to download the data in the datagridview in an excel format.How can i do it ? 1) should i write the dataset in the excel and save it the server before the user download the file ? 2) Can i use a hyper link and...
Hi, I want to convert an excel file to an image (every format is ok) programmatically (c#). Currently I'm using Microsoft Interop Libraries & Office 2007, but it does not support saving to an image by default. So my current work-around is as follows: Open Excel file using Microsoft Interop; Find out the max range (that contains data)...
Hello, The following VBA code sits in a worksheet called "SCU" and the cell "C4" is the information I would like to filter on. When double clicking on "C4" this takes us through to the "Account Data" sheet and attempts to filter on the active cell, however as it's on a separate worksheet I get the wrong data in the filter (Not "C4" in...
Is it possible to do a webservice call from within an Excel sheet that has been downloaded from a sharepoint server, using the same credentials as the ones that are used for accessing the Sharepoint server? We're currently developing an Excel solution, which does webservice request from within the Excel sheet. This works fine, but the u...
I have an Excel spreadsheet where there is a date column, and the date is entered in the format of dd/mm/yyyy. When I open this file in My Excel, the Date column converts to date, but in the format of mm/dd/yyyy automatically. i.e., 12/03/2009 4:44:44 (12March) but it takes it as 3rd Dec 09.. Would you please shed some light on the ma...
Hello! Let's say I have a 12 cells on column A with the sales for each month last year. To calculate a monthly I can do a simple formula like this in A13 =sum(A1:A12)/12. But in column B I have the sales for this year, not a complete year, and August is not finished, but I have the running amount of sales for this month, so far. What kin...
I have an Excel model that uses almost all UDFs. There are say, 120 columns and over 400 rows. The calculations are done vertically and then horizontally --- that is first all the calculations for column 1 are done, then the final output of column 1 is the input of column 2, etc. In each column I call about six or seven UDFs which call o...
Hi, Please suggest the best option to allow the user to download the data in the datagridView from the page in excel format to the client machine. I have a dataset that is binded to the datagrid view.Even it can be downloading the data in the dataset to an excel in the client side. PLease suggest whether this it is possible to generat...
I have an access database in which the field type is text and it contains 26 numbers. I converted it to excel, but it has only the first 5 numbers Text in database: 91234612345678912345678912 Text in excel : 9.12346E+25 How to get the entire field from database to excel? ...
In Excel, I want to be able to automatically break a cell into 2 or more cells if they contain a newline character (alt + Enter). How do I do this so that it'll divide the cell into new cells below that row? ...
how to change the cell format to text in excel programatically ...
Hi, Possibly, my questions do not presume a simple answer as I'm asking to share a specific experience. What kind of issues you experienced trying to execute Excel macros through COM Automation? Are there any specific requirements for creation of macros to be run through Automation? Can you share your experience with data (scalar and...
hi all... Take a gander at the following code. Basically, this is a function that gets called in order to identify the used range of a worksheet, loop through that range, and hash social security numbers. Here's the problem. If I create a spreadsheet and populate one cell, the function does not hash that cell. However, if I populate mo...
My data sheet has filters and hidden columns. When filter(s) applies, I need to loop through all filtered data. I use: Excel.Range visibleRange = this.UsedRange.SpecialCells(XlCellType.xlCellTypeVisible, missing) as Excel.Range; Now visibleRange.Rows.Count is 0; use foreach loop "foreach(Excel.Range row in visibleRange.Row)" row d...
I'm using the Dictionary class in the MS Runtime Scripting library to store where labels are going to go for a report template. Is there a way to iterate over all the key value pairs in that dictionary like in Python? I just want to use the key as the row number (It's all going in column A) and the value will be the label header. Some...
I have an Excel 2007 Sheet with Macros. When I click on a button, it immediately pops up an error "File Not Found: VBA6.DLL" Problem is, I have been using this sheet forever, and never seen this problem before. I did make some very very minor changes to the Macro code. And, I have 2 other sheets with identical macro code which I made t...
I need to be able to convert cells from one format to another according to the following rules: Property Description --enter as-- Folio Identifier ---------------------------------------------------------- Lot 23 DP789678 23/789678 Lot 7 Section 12 DP6789 7/12/6789 Lot 1 SP 45676 ...
In Excel, how do I write a formula that will partially delete a cell (from a certain point onwards). For example, if A1 is "23432 Vol 23432". I want B1 to just be "23432 " (everything from Vol onwards is removed). Thanks. ...
Hi, I've got an XML file which is a pain to manually update. So I was thinking of creating a small app which synchronizes this data for me based on data from an Excel Sheet or something. Could anyone point me in the right direction for this? Or does some software already exist for this purpose? The XML schema looks like this: <Data> ...
I am writing a reporting tool to document Excel files for various "compliance criteria", including wkb.VBProject.Protection to report if the VBA is locked. But how can I find if the workbook HAS any project ? If I calculate wkb.VBProject.VBComponents.Count - wkb.Worksheets.Count - 1 '(for the workbook) that will give me the number ...