All I'm trying to do is figure out how to change the cell in one worksheet to that of another when the one in the other is double clicked. In my second worksheet, I have the following code set up: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) End Sub My question would be what's the code to chan...
I have an excel spreadsheet that is going to be updated monthly and then displayed on a Blackberry browser. I've already created a website that has all the spreadsheet information in their statically and uses HTML definition lists and CSS to create charts. I'm looking for a way to load a new spreadsheet into the server each month and...
Hello all, I've a HTML table on my JSP page, that I want to be exported to Excel on a button click. What would be the best way of going about this ?(For ex., how would I do this using may be a jQuery function.) Any code examples for demo. purposes should be great. Thanks, Pritish. ...
I use OleDB to read an Excel file. One of the columns has a "Common" format and contains both strings with letters and values consisting of numbers only. String values are retrieved without problem, but pure numerical values are retrieved as DBNull. How to solve? I use the following connection string to open Excel 2003 file (xls): "Pr...
Hi Everyone, I'm writing a web app that will read data from an Excel file submitted by an authenticated user by opening an OLEDB connection to it. Can anyone tell me the security risks of opening up an Excel file this way? I know dangerous macros can be embedded in excel files, but is that still a risk when using a OLEDB connection? ...
I like to compress the xmldata before the data is provided to the client as an excel file. I am trying to compress and deliver it as a .zip file. its not working Here's my code below. Please help I tried compressing it, converting it to bytes etc etc. The issue with below code is, the XSL transformation is not happening properly and the...
I am trying to create a stacked column chart in VBA where there is a bar graph and each bar graph shows the breakdown of subcategories on the graph (See right side of picture). For the normal bar graph all I had to do was create a new series and set the Values and XValues properties. I'm not sure how to tell it about the values for the...
what is the simplest way to do a running number on a certain column starting with 1. ...
Hi, lets say I have a xls sheet with just one column which has the following content: 1 2 3 3 4 5 5 6 You see there are some cells with equal content. Now I want Excel to format (e.g. background) all cells which are there twice. I would say that conditional formatting is the right way but there I always have to enter a certain cell...
I need to open a excel file to see the markup. the xml format. I wont to open the markup of Office 2003 file in any editor. Any ideas? ...
I'm writing a SSRS report that is the direct result of a SSIS package. It is my understanding that SSIS must have exclusive access to Excel files for import. Is there any way around this? If I can't read what was there as of the last save, can I at least send an e-mail notifying the user of the failure? How do I catch that error? ...
I have created a SSIS 2008 Package which imports rows from a spreadsheet. I need to start on row 4 so I have used the OpenRowset property of the Excel connection manager. However, I need to import multiple tables. Can this be done with the Excel Connection Manager? I believe it can be done with an ADO.Net Source, but I don't know how ...
I have 3 cells that I want to use as 1 comment line. Is there a way to combine them into 1 cell so I can write a whole sentence across? Example: | content | content | content | I want to turn it into one cell without those cell separators: | content content content | ...
I made a XY plot that shows points from one data set in two different colors, depending on a set of conditions. I achieved this by making the source table three columns instead of two. First column is the X. Second column is Y is one set of conditions apply, third column is Y is the other set of conditions apply. So the second and third ...
I recorded a macro to print an excel sheet when the button is pressed. But I want to specify the printer that it automatically prints to rather than give the user a choice. I'm also printing to a PDF so is there a way I can choose where I print to? This is what I have so far: Sub Publish() ' ' Publish Macro ' Macro recorded...
I've created a lot of forms in Excel, which sum, calculate, highlight, index, etc. I can lock or unlock certain parts of it so that users can only edit the input fields, but it's nearly impossible to format Excel to anything other than a straight up grid. I have different inputs needed, in groups of different sizes, and formatting a spre...
we have some data (list) stored in sharepoint. i can manually click "Actions"-> "Export to Spreadsheet" and then run a bunch of code on the Excel output. I now want to do this on a daily basis from a C# application. Is there anyway to programatically automated that download steps that i am doing now. (the site DOES require authenticat...
I'm looking for a way to customize a column chart. Open office and Excel produce the following chart for a column with values 1, 2, 3, 3, 2. But, I'd like to generate a chart with the following properties. The chart should have five bars. All bars must be of the same height. The chart should color bars based on their values. In this ex...
i want to import data from excel into corresponding tables based on different column data's on based on ID's like customer data on based on CustomerID present in Customer master table Means we have to extract data from master table and excel source on basis of ID's Could you please help me out on this? ...
Even with the advanced technologies and available database tools (even free alternatives) are available today, it seems that huge number of users are still very comfortable in using Excel IN EVERYTHING! That's why, as a database developer working as one of these users, I am forced to let them use Excel simply because they are very comfor...