I'm interested in creating one or more spreadsheet graphs of interval metered data. The raw data is recorded as a continuously increasing value (i.e. total bytes, user logins, website hits) and date. Each sample measurement date will happen at a non-constant interval. For simplicity I would like to record the data in a spreadsheet progra...
If we export to Excel from the ReportingServices reports web site, the user gets an option to Open/Save/Cancel. However, the reportviewer control for winforms does not give the Open option. The user has to save the file and then open it manually. I'm wondering if someone else has already crossed this bridge and might be able to save me...
EDIT: This was happening because the cell was set to the button's LinkedCell property. When I set that to null everything works fine (of course, I was using that property, but oh well). Couldn't find anything on this through Google... I have a cell that contains a fair amount of text in a fairly narrow column. I would like to have a...
I have tried everything.but im not able to insert updat and delete the excel file..im able to connect the excel sheet.the connection also seems to be opened...here s my connection string: Dim sConnectionString As String Const kunal = "C:\" sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Sou...
At work we have to track our calls via an online application made via vb.net. To enter the needed info into the text boxes and drop down boxes you have to deal with more than one page. It is cumbersome to have to type or even copy and paste the needed info. I want to be able to type the info onto one page in excel and then have a script...
I'm trying to calculate the conditional median of a chart that looks like this: A | B ------- x | 1 x | 1 x | 3 x | y | 4 z | 5 I'm using MS Excel 2007. I am aware of the AVERAGEIF() statement, but there is no equivalent for Median. The main trick is that there are rows with no data - such as the 4th "a" above. In th...
I work on a product that loads a file into the Excel worksheet. The file contains data that is converted to a picture (using some WebService) and then displayed on the worksheet. Lately, I was thinking of avoiding the file IO in this load operation. If the import file contains 1000 records then the load method has to create and delete 1...
Anybody know what the limit is for the comments on an Excel cell (2003)? I'm programatically filling this in and want to make sure that I don't exceed the limit. ...
I have 3 Worksheets. Following is an explanation of what I am trying to do. EM11 EM12 EM01 The steps below are meant for Sheet EM11 but I want to repeat them FOR Sheet EM12 and Sheet EM01 Select Sheet EM11 Copy J2:J65636 and copy G2: G65636 Create a new worksheet called EM11-Count Paste Column J into cell A2 of new worksheet ca...
Hi, I am using c# (visual studio 2008) to try and access business logic in an excel spreadsheet. I have the following class.. (feel free to criticise if I am doing this wrong - I am java developer normally - this is my first c# application.) public class SpreadSheetClass { // apologies for any typo's code written in place, not cop...
I generate an excel file using XML format outlined on stackoverflow in the following post: Generate excel file in .net However, when I open it up in excel 07, I get the following message: The file you are trying to open, "blah.xls", is in a different format than spefied by the file extension. Verify that the file i snot corrup...
hello, i am trying to run a solver optimisation through vba 6 excel. but when the execution reaches the declaration of the objective function: Sheets(working).Range("B63").FormulaArray = _ "=MMULT(MMULT(decision,covarMatrix),TRANSPOSE(decision))" it gives the following message "run time error '9' Subscript out of range" ...
We have just updated an application which uses the Excel type library to Delphi 2009 from Delphi 2006. What I am finding is that nearly nothing now works - nearly any call to Excel results in a message "Bad variable type.". For example we may do: Sheet.Cells.Item[Row, Column].Value := Value where Sheet is an ExcelWorksheet and Value is a...
I am supplying the correct password Set objExcel = CreateObject("Excel.Application") Set objWorkbook = objExcel.Workbooks.Open("H:\M\X\C.xls", 0, , , "password") 'any of these lines cause the error mentioned Set vbcomp = objWorkbook.VBProject.VBComponents(modname) objWorkbook.VBProject.VBComponents.Remove vbcomp objWorkbook.VBProject...
I have an SSIS package which reads an Excel File (Data Flow Source) and transfer the data to SQL Server using OLEDB Destination Data Flow Item. The OLEDB Connection Manager used for the destination is configured to use Windows Authentication. The package works fine on my development machine. But when I open the same package on another ma...
Hello. I have created an application that uses Microsoft.Office.Interop.Excel, in my local and testing environments everything worked fine, but the app does not work in the production environment. Turns out I have Office installed locally, as does the Test server, however, the production server does not have Excel installed. I reall...
I am building my first database driven website with Drupal and I have a few questions. I am currently populating a google docs excel spreadsheet with all of the data I want to eventually be able to query from the website (after it's imported). Is this the best way to start? If this is not the best way to start what would you recommend?...
Hi, does anyone know if there's any good online tutorial for building pivot tables using Interop.Excel.PivotTable? These are the only two I can find: http://blogs.msdn.com/andreww/archive/2008/07/25/creating-a-pivottable-programmatically.aspx http://www.dreamincode.net/code/snippet1217.htm And I'm looking for more complicated example...
Is there any way to implement a custom data source that works with the "Import External Data" feature? Let's say I have data in a file format that Excel doesn't understand. I'd like to implement an add-in (or whatever) for Excel that allows it to understand this format through the "External Data" feature. Obviously, I could just con...
I know it is possible to get data from a SQL database into an excel sheet, but i'm looking for a way to make it possible to edit the data in excel, and after editing, writing it back to the SQL database. It appears this is not a function in excel, and google didn't come up with much usefull. ...