Hello everyone, I'm using SSRS 2005. In my report, I'm getting data to a table with paging(use with grouping). It's ok. But when I export data to Excel file, RS divide data within multiple sheet. How can I get data in only one sheet while exporting to Excel? ...
Is it possible to have a shared worksheet with macros? We have created a sheet with a basic macro (enter in name, auto-populates the date). But now the sheet can only be edited one at a time. Is there a solution to this? ...
I have a named range in Excel (that was created do to making a Web Query in Excel)... how do I get the sum of just the "Amount" column? Example: This works: =SUM(MyRange) The problem is, that sums EVERY numeric looking field (so "Amount" and "UserID" are BOTH being included in the SUM function). What I need is this: =SUM(MyRange["Amou...
SCENARIO My users will copy cells from Excel (thus placing it into the clipboard) And my application will retrieve those cells from the clipboard THE PROBLEM My code retrieves the CSV format from the clipboard However, the if the original Excel content contains characters like ä (a with umlaut) then retrieved CSV string doesn't hav...
Hi, I want to extract data from PowerPoint slides and then paste them into Excel workbook, where each slide in PowerPoint corresponds to a sheet in Excel workbook and vice-versa (from Excel to PowerPoint). How do I do this? I extracted the data PowerPoint but now how do I make it send to data to Excel? What options/possibilities do I ha...
I'm looking to allow the user to export an reporting service report to Excel. The question I have is how do I specify a formula within Reporting Service which is then present as an Excel column calcualtion on the exported file? Currently all I can seem to export is end results of the Reporting Services report but I have a need for the u...
Ok so here's the problem, i use a connection with using(connection.... blah blah) and then after my using block is over I want to start the excel aplication like this: System.Diagnostics.Process.Start(excelFile); This works... sometimes, other times my computer runs too quick and before the file is fully close, or the connection is full...
Platform: WinXP SP2, Intel Fortran 11, Excel 2007 I'm having trouble connecting a dll file with excel. The dll file is relatively simple: subroutine FortranCall (r1, num) !DEC$ ATTRIBUTES DLLEXPORT, STDCALL, REFERENCE, ALIAS:"FortranCall" :: FortranCall integer, intent(in) :: r1 character(10), intent(out) :: num !DEC$ ATTRIBUTES REFER...
This is somewhat related to my other question. I've been using a dll to acompany an excel spreadsheet. Everything is currently working with the dll and excel is using it just fine. But is it possible to specify that a dll resides in the same directory as the excel file when declaring functions? Declare Sub FortranCall Lib "Fcall.dll" (...
hi, i have 2 qns, hopefully simple enough for you to help me with. 1) i have 2 adjacent cells A and B. A is a validated list where it has 2 values. B should show something else that is dependent on A. my intention is to set this macro on a button and everytime the button is clicked, the 2 cells appear. 2) i have 4 cells- C, D, E. cells ...
I'm lokking forward a library like google docs(speret sheet) I examine these structure on WEB, but there is not detailed explanation and is hard to understand it, and it is it to implementation in the long way off when I really become the part called the cooperation with DB. There are many introductions about a sort in particular and pag...
MS Excel has the following acceptable mime types: application/vnd.ms-excel (official) application/msexcel application/x-msexcel application/x-ms-excel application/vnd.ms-excel application/x-excel application/x-dos_ms_excel application/xls application/x-xls Is there any one type that would work for all versions? If not, do we need to ...
Hi, I am creating an excel file using php like this: header("Content-type: application/vnd.ms-excel"); header("Content-Disposition: attachment; filename=invoice.xls"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); echo "<table><tr><th>Test</th></tr><tr><td>...</td></tr></table>"; When I try open the file, excel...
Hi, I have an HTML page which has a flash chart(FusionCharts) and HTML table. I need to convert this whole thing into Excel. HTML table should be displayed in cells of excel sheet. Flash chart can be displayed as an image. Is there any open source API that we could use for achieving this. Could you let me know what are the possible opt...
Hopefully you guys can help me out. I tried a lot of different things and cant get this working. I have a gridview as below in a update panel: <asp:UpdatePanel ID="udpReport" runat="server" UpdateMode="Conditional" ChildrenAsTriggers="true"> <ContentTemplate> <asp:GridView runat="server" ID="preferenceReport...
Does anyone know if a site (even non-Microsoft), that has details on COMExceptions/HRESULTS. When I attempted to Save my Excel Workbook after using the Copy() function, I received this error: ERROR - Unable to SaveWorkbook() System.Runtime.InteropServices.COMException (0x800A03EC): Document not saved. P.S. I'm doing this in a tight ...
Hi, I'm no php expert (a mere beginner) but need some help! After hours searching Google and trying out about 100 different scripts, I finally found one that does what I need - almost. Basically, my site has a button marked 'Export to Excel'. Visitor to site clicks button and a download begins containing all data from a specified tabl...
Hi, I am working on a spreadsheet with lots of VBA code in it. Most cell references use numbers, e.g. Worksheets("Sheet1").Cells(someRow, someColumn) I am wondering if there is any easy way to find out exactly which cell is being referenced - is it possible to put a breakpoint on this line of code, and then see which cell it will ref...
Hello, I have a problem with Swing GUI which automatically closes when we run export to excel operation with more than one time continuously. The operation consists some 25 tabs data and each tab is having a table with more than 1k rows.This is a JNLP based application with 1024 mb RAM specified in the configuration file. Thanks in adv...
I am using MS Excel to do my data analysis. I have two dates. One date is my forecast date. For example, i am forecasting the stock to arrive - 06/09/2009. Another date is the actual stock arrival date - 06/10/2009. I know that the date difference is 1 day. What I would like to calculate is the accuracy of my forecasting. If forecast d...