Hi, I need to know how to do the following filters: Filter a date column to show weekend dates only Filter a date column to show the first and last day of a month only Filter a number column to show round numbers only (e.g. include show 12 but filter out things like 12.12) Thanks. ...
I've a requirement something like this. I've to convert an Excel to XML Spreadsheet. After googling, I found jexcelApi. But it's not retaining the format. Any suggestions on How to convert an Excel to XML format, retaining the Excel formatting? Thanks :) ...
I have written several Subs to show/hide fields in a PivotTable. Now I am trying to do the same with a calculated field, but I get an error when hiding it. I took my code from the recorder and the recorder's code also halts on the last line. I googled the error message, without serious result. Sub PrRemove() 'remove PR Dim pt As...
While writing and saving excel file from xp works but same code gives error in vista saying The file name or path does not exist The file is being used by another program The workbook you are trying to save has the same name as a currently open workbook ...
I am seeing some odd behavior in SQL Server AVG calcuation. On manual calculation, you get 49.277588 but SQL Server is reporting that the average is 50.9914 as shown below. Question: Can someone explain the difference and why this is happening? You can try out the query on AdventureWorks2008 Database with following query select C.P...
I want to know if it possible to repoduce the idea of Excel 2010 sparklines in a SSRS 2005 Report. I want to show a report that has an indication of the price fluctuations over a 3 month period for a range of products. I could just give the figures over the 3 month period but it is very hard to quickly distinguish what is happening to ...
Hi I created a custom report for CRM in SSRS. within this report I have some number (decimal) fields that are summed. I need to be able to export this report to Excel to allow for changes (some times the user needs to make custom changes to the data) but I need the sum fields on the group to actually be a formula field so that it is u...
Hi, I have used this code from link below to send excel file as attachment. http://www.hotscripts.com/forums/php/22626-php-form-excel-then-send-email-attachment.html Here is the code I have used: <?php ob_start(); ?> <html> <head><title></title> </head> <body> <body> <center> <table> <tr> <td>Name:</td><td>My Name<...
I've got a bunch of huge excel reports created by JExcel. Now the company's styleguide has changed and somebody had the great idea to add some logos to the footer. Unfortunately, adding images to the header or footer is not possible with JExcel. As a workaround, I am currently modifying the PDF files created from the Excel files with iTe...
I am posting this query again.Soory, but I dont know how to ask doubts about already asked query. I am using a COM dll as a reference in my Project. I want that dll to be referenced from any location of computer. <runtime> <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1"> <dependentAssembly> <assemblyIden...
I have a set od Excel (2003) sheets saved as ".xlt" format. Now ,how to change the spreadsheets from templates to workbooks? Further can any one make it clear what is a Excel workbook and what is Excel template? Differences? Does not a workbook contain multiple worksheets? Thanks and Regards Vas ...
Hey all, I am writing an automation to update the contents on an excel sheet(in c#) present on our server. Our server has various portals and has different credentials. How could I fetch the file on my portal to my local computer to make some changes to it. ...
hey Folks, I have a windows app in c# .NET which requires access to the file on the sever. Ex:--user A has his credentials as A and pswd. He has server space where he has the file i need. i have the credentials. I can access it using our website. But, i need to access it using a windows app Imagine i need a file stored on the mail a/...
I'm trying to develop an AddIn for Excel 2007, and have a solution full of code that executes and debugs just fine on other people's machines. When I try and Start Debugging in Visual Studio on my machine though, Excel gives me an error when it loads my AddIn: "An AddIn could not be found or located." I then click on the Details button...
Hi there I'm highly annoyed because I've been trying to print excel charts in word and I'm not getting any love. I have 170 graphs or so that need to be put into word (so I can have 2 per page) and then printed as an Appendix to a report. I'm transferring the graphs by dragging the actual excel file and dropping into word as this is the...
I was wondering about the best way to do this: I have an app that works with the Excel DOM. Users may have either Excel 2003 or 2007 installed, I don't know which one a priori. Mine is a C# console app. How can I make my app compatible with both? Is it possible at runtime to find what version and modify the Using statements accordingly...
I am using ADO.NET to fill a datatable from an Excel (xls) worksheet. I got unexpected chars. At first I thought they came somehow during the import and so I tried to emininate them in the C# program but nothing I tried worked. Finally I traced the chars back to Excel and I was able to use the replace function in Excel to replace the c...
Hello, I am building a windows form application using visual basic (visual studio 2008). The idea is to query a MySQL DB and export the results to an excel document. I managed to do this using this code (I will just show the export to excel part): Imports Excel = Microsoft.Office.Interop.Excel Imports System.IO Imports System.Da...
I am currently developing an application that requires an excel spreadsheet, location selected by the user, to be read into a DataTable and then stored in a sql server database. The application works perfectly in my development environment, however when it is deployed into my production environment an exception is thrown with the follo...
I'm starting to study Python, and for now I like it very much. But, if you could just answer a few questions for me, which have been troubling me, and I can't find any definite answers to them: What is the relationship between Python's C implementation (main version from python.org) and IronPython, in terms of language compatibility ? ...