Hi, I'm a beginner of ASP. I'm maintaining at ASP 1.0 page and I want to reload the page with an additional parameter when user click client-side URL. Its important that it also keeps the current parameters. The objective is to export the table currently display in Excel. So I want to reload the page with a special parameter that w...
I have exported datatable to Excel successfully. Now I have to change some cell color using Conditional formatting in Excel sheet using C#. For example if a cell contains text as "Cat" it should be display in Green color and if a cell contains text as "Dog" it should display in blue Color. Now how can I do this? ...
Hello, I am using MS Office 2007. Please let me know that how can I copy whole data from sheet one to sheet two. I want to copy the whole data from row 5 to onward in sheet two. The whole scenrio is given below in detail. Sheet one: Copy the data from column B and Row 3 Sheet Two: Paste the Copied Data in Column B and Row 3 Shee...
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. T...
Hi, I'm trying to call a function when a workbook is being opened. I used workbook_open() event. But I notice that before calling function which is inside workbook_open(), all the functions that already exists in the workbook are being called. How can I call my function to execute before calling any of functions in the workbook? Thank...
Can I use a web service as a data source for creating Excel pivot tables? Currently, the soure data for the pivot table is being exported from our SQL db to a CSV file. Then, the CSV file is loaded into a worksheet. From there, a pivot table is created in the same workbook. Customers login to a website, click some links, and an excel f...
I have a CSV file. The first row will always contain column headers. Depending on a variety of factors, the order of columns may change and, in rare circumstances, some columns may not be present. These changes are beyond my control. My thoughts, so far, on how to address this. I'll read the first row of the file and use the values to g...
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 ...
I can read and write an Excel XLS file from Microsoft SQL. However, I need to force Excel to a recalculation before the read. How can I do that from T-SQL? Is the only way a .Net wrapper on a 3rd party library? ...
Hi All, I am having some trouble with the relative referencing, when trying to cycle through conditional formats in an Excel sheet. What I am trying to do is loop through the conditions, evaluate them to see if they are true, and if they are, applying the background color of that condition to another cell. I know that .formula1 has so...
http://stackoverflow.com/questions/1357121/executing-word-mail-merge-from-excel-macro Is there anyway to set it up to send the mailmerge to the printer rather than create a new file? ...
I have an Excel spreadsheet that will sit out on a network share drive. It needs to be accessed by my Winforms C# 3.0 application (many users could be using the app and hitting this spreadsheet at the same time). There is a lot of data on one worksheet. This data is broken out into areas that I have named as ranges. I need to be able...
im doing a bunch of stuff to the variable St For i = 1 To 30000 Randomize e1 = Rnd e2 = Rnd z1 = Sqr(-2 * Log(e1)) * Cos(2 * 3.14 * e2) z2 = Sqr(-2 * Log(e1)) * Sin(2 * 3.14 * e2) St = So * Exp((r - (sigma ^ 2) / 2) * T + sigma * Sqr(T) * z1) C = C + Application.WorksheetFunction.Max(St - K, 0) St = So * Exp((r - (sigma ^ 2) /...
I've written lots of Excel macros in the past using the following development process: Record a macro. Open the VBA editor. Edit the macro. I'm now experimenting with a Visual Studio 2008 "Excel 2007 Add-In" project (C#), and I'm wondering if I will have to give up this development process. Questions: I know I can still record mac...
Can anybody point me to a reference or just explain about how to parse an Excel file in general? ...
I want to validate range of excel worksheet (e.g. "A10:B20") to check that is it has error or NA value or not? How to do that in C#? P.S. I find similar topic (Excel range usage question (cell error checking)) but that topic is not thing I need. ...
Hi. I’m trying to run a excel macro from my C# code, but I'm getting the following error when trying to execute the code. The code is: static void Main(string[] args) { object oMissing = System.Reflection.Missing.Value; Excel.ApplicationClass oExcel = new Excel.ApplicationClass(); oExcel....
I am using the Scriptom extension to Groovy 1.7.0 to automate some processing using Excel 2007 under Windows XP. This always seems to leave an Excel process running despite my calling quit on the excel activeX object. (There is a passing reference to this phenomenon in the Scriptom example documentation too.) Code looks like: import ...
In Excel, let's say I have 5 columns, but not all of the time will a column have data. How can I force it to give a static number of commas? I end up having some rows like this (as I would like it): Field1,field2,field3,field4,field5 field1,field2,,, Then some rows like this: field1,field2,field3,field4,field5, field1,field2, fi...
I have an excel workbook vsto solution that needs to generate a pdf copy of one of its sheets as output. I have a license for abcdpdf .net and tried outputting to html, then using abcpdf to convert the html to pdf, but the excel html markup tries to emulate excel with all 4 worksheets with horrible markup. It also messes up the colors ...