I find it quite unbelieavble that the interop API is such a mess A lot of methods have no comments on and seems to have been done very poorly Has anyone else experienced the same and if so what library do you use to control Exel from C#? ...
Morning all - another day, another question from Rich! I have the following scenario. I have two methods of populating a GridView with data. These are as follows: protected void btSearch_Click(object sender, EventArgs e) { lqPackWeights.WhereParameters.Clear(); ControlParameter cp = new ControlParameter(); cp.Type = TypeCo...
Hi, Im coming from a Unix world where I never had to develop something for Office with VBA, I have to do some now and Im having a hard time! Please help me! :) So I've got 2 Excel Sheets(lets call them Sheet1 and Sheet2) and 2 forms(Form1 and Form2) to edit/add data. In Sheet1, the first two columns are MovieId and MovieName. We dont ...
When right-licking on a HTML page in IE6 (our company standard), there is an option "Export to Microsoft Excel". Can this option be fired via javascript? ...
When right-licking on a HTML page in IE6 (our company standard), there is an option "Export to Microsoft Excel". Can this option be fired via embedded VBScript? ...
I recently discovered, however, that all public functions are displayed in the "Insert Function" dialogue box when you select "User Defined" in the "Or select a category" drop down list. This happens even if you password protect the project and lock it for viewing. To get to the "Insert Function" dialogue box press Shift-F3. Private f...
This part of my code was creating xls file successfuly FileOutputStream fileOut = new FileOutputStream("c:\\Decrypted.xls"); wb.write(fileOut); fileOut.close(); when other part of the code had this statement ( which was before the above code ) in = new ByteArrayInputStream(theCell_00.getBytes("")); But when I changed it to in ...
Excel 2002 VBA. I have a macro that launches an external script whenever a certain condition is met: Shell("c:\program\script.exe") How do I stop that running program when the condition is not met? ...
can we execute a formula without moving cursor from the cell? After giving data in to Input cell either we press enter or we move from that cell and then any formula related to that gets executed. Is there any way that while entering input itself we can see the result in output in excel?Please help me in finding this option. ...
Hi all, Basically I need to gather a fair few figures from another workbook (Which is found and can be opened by a UserForm, therefore the location and names are variable). I need to use VBA for this as I also need to populate a chart with this data. I would prefer to not have to open the other workbook in order to do it, but if it is f...
This my example code: $objPHPExcel->setActiveSheetIndex(0); $objPHPExcel->getActiveSheet()->SetCellValue('A2', '1.0'); $objPHPExcel->getActiveSheet()->SetCellValue('B2', '0.0'); $objPHPExcel->getActiveSheet()->SetCellValue('C2', '1.2'); $objPHPExcel->getActiveSheet()->SetCellValue('D2', '100'); Iam getting in excel sheet is round off v...
Hi, Any idea how can i force the merge of excel cells when exporting a rdlc report to excel? Primary KEY |VALUES| PK1...............|val1.....| .....................|val2......| .....................|val3......| PK2 |..... | ..................... i want that on first column(Primary key column) in the exported excel, the ...
We generate an Excel spreadsheet in our C# .net website by writing out an HTML table to Response. This works great, but the sheet name gets set to the same as the file name. Is there away to set this? We require a certain sheet name when importing. Code: string filename = String.Format( "{0}-CopyDataBack_{1}.xls", Master.EventID.ToStr...
hi folks, i´m programming a vsto add-in combined with an automation add-in in VB.NET using MS Visual Studio 2008. The automation add-in is activated in excel and registered at the system. basically the automation add-in running very well, when you call the function with "=<function-name>(<argument1>;<argument2>;...;<argument-n>)" by w...
I'm looking for an Excel 2003 macro to solve this problem. I have a sheet that holds financial information: A1 holds client names and AI1,AK1,AM1 etc, hold months April, May, June (all string values) etc; with the rows below that holding the amount due for the corresponding month. The last row is the total. What I need is to cre...
Hi, Sorry I have just created an abccount and lost the thread for the last query I just placed. Anyone know how to link it back up with my openid? Query below. This is really another question linking with the question before. I have an issue where I have a code written however it will only let me select 22 columns then comes up with 'to...
On the application I am currently working on, we need a way for users to generate reports in Microsoft Word or Excel format (export and print). One of the requirement is that the users would create the report template using a Word or Excel template document. I've tried to google a reporting tool that uses word and excel templates for r...
I'm using OLE to connect to a database using VB.NET, and show the results in a DataGridView. I want to export the data that is in the DataGridView to an Excel format file, i.e., the user can save the content of the DataGridView as MS Excel file. ...
I searched all over could not find a solution. ...
If I need to automate a series a task on an excel sheet like remove all rows where column 3 contains value "asdf" remove column 7 and column 9 sort according to column 4 etc. What is the easiest way of automating such tasks in excel? I think it would recording a macro but sometimes macro have to be edited a lot to actually make th...