I've got some Excel spreadsheets that are hitting the database pretty hard (100+ queries against the general ledger table... yikes!). Refreshing just the sheet I'm on (SHIFT+F9) is helpful in some spreadsheets, but I wanted a way to refresh just the selected cells. I'm came up with the following code, placed in the ThisWorkbook object: ...
Hello all you amazing people I wanted to do two things populate a unique distinct list from a long list of repetitive values extract component of a text delimited with hyphen I found solutions to each one of these problems at different places. Unique distinct list here: http://www.get-digital-help.com/2009/03/30/how-to-extract-a-un...
I am having my xml data in XDocument (LINQ). I want to write this data into excel data. I am using console application. I dont want to use excel com object. ...
I'm using Excel Interop assemblies for my project, if I want to use auto filter with then thats possible using sheet.UsedRange.AutoFilter(1,SheetNames[1],Microsoft.Office.Interop.Excel.XlAutoFilterOperator.xlAnd,oMissing,false) but how can I get the filtered rows ?? can anyone have idea?? ...
hi, in excel vba i have added a commandbutton to userform... like below Set ctrl = Me.Controls.Add( _ bstrProgID:="Forms.CommandButton.1", _ Name:="CommandButton1", Visible:=True) Now I wanted to know how would I tell it what to do when it is clicked? thanks!! ...
I am currently working on a project for traversing an excel document and inserting data into a database using C#. The relevant data for this project is: The excel sheet has 14 rows at the top that I do not care about. (sometimes 15, see Russia/Siberia below) The data is grouped by name into 2 columns (date and value), such as: Sh...
Hi, Is there a way to download an Excel file from a J2EE application to an IE browser over https. My code works fine with Mozilla but IE just gives an error. I know that Excel over https is a problem for IE. While I've seen solutions for some environments, I haven't seen anything for J2EE. jd ...
I have data that looks like the following: ID | Location | Attendees | StartDate | EndDate --------------------------------------------- Event1 | Bldg 1 | 10 | June 1 | June 5 Event2 | Bldg 2 | 15 | June 3 | June 6 Event3 | Bldg 1 | 5 | June 3 | June 10 I'd like to create a time series grap...
Is it possible to import excel data to display using C# in any view(data grid etc ..) while retaining formatting like Bold, italic and strikethrough, throughout the document. I am making a windows form application. My data is in an excel sheet , i want to display it in grid view or any other while retaining the formatting. PLZ help. ...
I have to use OleDbConnection to create a new excel file, but when I open connection with this string: OleDbConnection excelConnection = new OleDbConnection( String.Format( @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Mode=ReadWrite;Extended Properties=""Excel 12.0;HDR=Y...
I want to call Excel Sheet from C# 4.0 (VS 2010 Express Edition) . When i declare , Microsoft.Office.Interop.Excel.ApplicationClass excel = new Microsoft.Office.Interop.Excel.ApplicationClass(); excel.Visible = true; I receive error as Interop type 'Microsoft.Office.Interop.Excel.ApplicationClass' cannot be embedded. Use the ap...
for some reason in my VBA code in excel, when it gets to a line of code where i am using mid it says can't find project or library. what does this mean? ...
I'm building an Excel 2003 VSTO workbook level customization and have placed windows forms buttons and comboboxes on the worksheets. I also have a freeze pane set on the sheet that divides the sheet into 4 sections. 1 2 3 4 The controls I place on a pane that can be scrolled, such as 2, would become deactivated (turn into the image plac...
Goal: Step 1. Use a PowerPoint presentation during a seminar that allows the presenter to click on text fields and fill in information while still in "slideshow" view. Step 2. Copy (in any way) the entered information to a word document. Currently one the slide in question I have a table in powerpoint with msotextboxes overlayed over ...
does anyone know a programmatic way to determine whether an excel file has a macro with it? i have hundreds of excel files and i need to know which files have macros in them? ...
Hello, Is there .NET component which can convert XLS to password protected PDFs? Thank you in advance. ...
Dim cht As Chart Dim Xleft As Double, Ytop As Double Xleft = cht.PlotArea.InsideLeft i am getting this error on the third line. does anyone know why? here is the full code. please keep in mind that this is excel 2003 Sub DrawSmoothTransparentShapesOnRadarChart() Dim cht As Chart Set cht = Worksheets(1).ChartObjects(1) ...
Hello, On my computer report is generated in about 3-4 seconds, and it was like this on all computers before. But recently on a couple of computers in the office report generating started to take 30-40 seconds. On other computers it is still fast. I tried to reinstall MS Office with no luck. For example, this code takes !!! 3 !!! seco...
does anyone know how to place buttons or textboxes on worksheet with vba or manually? ...
In Excel, the Offset function returns a reference to a range that is offset a number of rows and columns from another range or cell. can someone please tell me what that means? for example in this formula: =OFFSET($B$4,ROW()-ROW($F$4),0,1,1) what is it doing? ...