I am trying to capture worksheets being copied in to a workbook from another workbook. Workbook_NewSheet event does not trigger when the sheets are copied from another workbook. It is triggered only if the user manually inserts them through (Insert->Worksheet menu option), or when you add a new sheet through VBA as ThisWorkbook.Workshee...
Hello, Am trying to convert the content of a page to an Excel format, the problem is when I redirect the page I don't get my request variables so I found a solution that we should define a hiden variable for each request variable and then define the value after Get call. This is the code that am using now : <script language="Javascript...
Hi all, Could anyone suggest best way to export data to .xlsx format. 1.Dynamically creating sheets. 2.customizing the data in each sheet. We can't use office web components. Thanks ...
I want to change it from one database to another. There don't appear to be any options to do this on the pivot table context menu ...
I have an xls with a pivot table using a proc to populate it. I deleted the data connection in 'admin tools - odbc - file DSN' and it still works, how is that possible? Does that mean that the recipent doesn't have to have the file DSN present in order to see data in the pivot table? ...
Working in an asp.net 2.0 (VB) environment, I already have code that can generate an excel file from a database for a particular "user" of the website. I want to be able to launch this report generator on demand, and then after the file has been generated, allow the user to download this file. How can I do this securely, and not just ...
A client wants to "Web-enable" a spreadsheet calculation -- the user to specify the values of certain cells, then show them the resulting values in other cells. (They do NOT want to show the user a "spreadsheet-like" interface. This is not a UI question.) They have a huge spreadsheet with lots of calculations over many, many sheets. B...
I wrote a macro that imports a CSV file into my spreadsheet, using a QueryTable. My goal is to import the CSV data and be able to save it in the spreadsheet for future reference. However, the QueryTable updates with the external CSV file, of course, and I would like to prevent this (because I want to forget about the external file). ...
NOTE: this question is almost a dupe of: http://stackoverflow.com/questions/284092/stop-ms-excel-auto-formatting-numeric-strings-as-numbers I say "almost" because this specific question was not asked ... Question: Is there a way to attach a "schema" to a CSV file, prior to Excel import, that allows Excel to understand the correct form...
How do I convert from excel serial date to a .NET date time? For example 39938 is 05/05/2009. ...
I'm working with ASP.NET Webforms and I need to create an report as a Excel file. That should be easy, by changing the ContentType, but I need to dynamically add formulas to some cells. Any Ideas? PS: The format of the excel file should be XLS not XLSX. ...
I want to add my data stored in 2x2 dimension array in Excel using Perl. I know how to open and add simple data. This I can do using for loop. But how can I do it elegantly? This is what I am trying to do $sheet->Range("A1:B"."$size")->{Value} = @$data; or @data; ...
I am looking for a .net library that can help me do one of the following: 1. Convert an MHT file to PDF 2. Convert between pdf versions 3. Change a pdf file encoding 4. Convert an MHT to an Excel file 5. Convert a MIME version of excel (an Excel file that is readable via notepad) to a binary Excel file 6. Convert between Excel version ...
The first part is now working [ I have the following which just seems to hang; the part that adds/deletes the module works when running in VBA I note that I'm prompted with a dialog saying 'this workbook contains links to other data sources' which I ok to, then it hangs So I tried setting the second argument to 0 and also tried 2 but sti...
Is it possible to extract information from an excel file (.xls) into c# on a computer without excel installed? I've got the following code: OleDbConnection objConn = new OleDbConnection(CONNECTION_STRING.Replace("<FILENAME>", fileName)); try { objConnection.Open(); ...
This is child's play for all of you, but I don't know Visual Basic at all. How do I write a statement to insert a row between two rows in an Excel spreadsheet repeatedly? An example below: F-3757 - GROF FILTER REWORKLIJN F-3758 - POEDERAFSCHEIDER F-3759 - FIJNFILTER F-3760 - STOFILTER F-3762 - AANZUIGFILTER B-3771 - VENTILATOR STORTKO...
Please send code samples if you can, Thanks! ...
Hello everyone, its a bit confusing to write my idea but ill give it a try. Here is what i was able to do. I have a drop down on my vertical cells, so i have a list of names to pick from which is linked by [name]-> [define] and [data] -> [validation]. what i would like is another vertical cell to populate another drop down depending on t...
Is it possible to declare variables in Excel cells and use it as parameter for formula in other cells? For example I would declare var1=20 in one of the cells. In other cells I would use var1 for calculation like : =var1*20. Thanks... ...
Is there a way of displaying the Cell name of a particular cell in another cell? I would like to display the cell name in the adjacent cell so that the user is able to identify the cell name without clicking it. Thanks... ...