I would like to use redis to query data from commandline, scripts, web and from within spreadsheets. I can find good examples for all but spreadsheets... I don't quite know where to start for access from a MS Excel spreadsheet, though. Google is failing me. Please let me know how you would suggest doing this, thanks! p.s. for those u...
I'm having this problem: The SQL Server holds a said value, let's say 990.30, the Reporting Services Report show a different value (948.33) when viewed online, in the brower and a third value (912.22) when the report is exported to Excel. There are no formulas on Excel, just plain values. Also, there's no formula on the layout of the r...
I've had some code that has worked for years to export an html table to Excel. It goes like this- private void ExcelExport ( string core_number ) { // set response up for excel export Response.Clear (); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader ( "con...
Hi, I need to set/insert hyperlinks for a range of values in an Excel sheet from my program written in Visual C#. I am using "Microsoft.Office.Interop.Excel" and no third party Excel tools. I have URLs in string format with me in the program which need to show up as Hyperlinks in the Excel workbook. Any ideas on how this can be imple...
I have an Excel 2003 "application" that at this time the users refuse to part with. I am updating it to use a .NET class library for some of the calculation, to try to minimize the risk of using excel. This .NET Class Library calls a .NET WCF Web Service. When trying to call a function that utilizes the web service, the class library th...
When I typed that title, I came across many help topics and looked up few of them and got some basic idea. I still am stuck and that is why creating a new post to get some guidance. Scenario is this: My excel sheet has Y or N letter in A1, some text in B1 and a valid future date in C1. I currently have a VBA script that does this for ...
Hi, I am looking for tools which would help me create & analyse surveys. I have a list of about 8000 questions and the answers expected are a fixed set {Yes, No, Can't Say}. Does Excel/Google Docs allow me the liberty to implement such a requirement in short time? ...
I have designed an user interface for a tool where the user needs to enter a "Name" which is maximum 300 characters long, and the tool generates a text file ("Name".txt) which is then uploaded to a "server" (Mainframe and Unix). I want to shorten the 300 character string into a uniquely identifiable 8 character string (because of issues ...
I'm looking for a simple way to recreate a relatively complex Excel sheet with a macro, inculding cell values, formulas, formatting, and cell size. Basically, I have an Excel sheet and I need the VB code that would create the sheet. I.e. somewhat like using the macro recorder, but without having to do all the steps in sequence. Any ide...
Hi. I have some plain text file (.xls extension) with next markup (attached below). It's opening in excel 2003 without any error. Now I need to know what is the name of technology, when I could create excel file through html markup? Becouse I need to fix this file to open correctly in Excel 2007 and earlier. (I see "file in the diffe...
Was wondering if there is an easy to convert structured files into YAML data fixtures for Doctrine / Symfony. I don't see any utility with Doctrine to accept CSV. I might just start writing something simple to do this. Is it worthwhile? ...
i have an XLAM macro that runs as an add in. can i write a script in any language to identify the user (IP address or name of computer) who is currently using the macro?? ...
Hi, I'm having problem importing a csv file with <br /> contents in it to excel. It includes the data after the <br /> tag to another column which it seems the <br /> tag becomes a delimiter. ...
This is similar to my last question, however I feel it has to do with another level. Project1 is the MDIForm with a menu item for Reports. One of the reports is an Excel 2007 Workbook project. Both projects are in the same solution. My question is, how do I run the Excel 2007 Workbook project from the Project1 when t he menu report item...
Hi i have my text file in this format **4 1250000209852 01 XXXX XXXX V 3054XXX, XXXX J. 73227DUONG, DUC H. 672XXX COMM HOSP 40352405 RO 07/07/201010/05/2010HO 331.5 XXX NL PRESS XXX ...
Filter data option in excel is useful to filter data based on a certain criteria. How do we make the header(s) shown at the top always as we scroll down the excel sheet. ...
For a Java application that drags data together from some sources and does some calculation itself, we want to offer users the possibility to use their own format strings, and would prefer the format string syntax they know from Excel (e. g. "$ "#,###.,0) which happens to be the same used in .net and Analysis Services. The closest thing...
Hi, I'm currently working on a document which has about 25 columns, each headed by a date. Now I have to sort these columns by date. However, the sorting should not start with January and run until December. In my document, the sorting should start with September, and run until June (July and August can be omitted, as my document relate...
I'm looking to update all of the auto filters on the Workbook_Open event, but not really sure where to begin and wondering if there is something as easy as refreshing the Pivot Tables which I had done with the. ThisWorkbook.RefreshAll ...
I'm using the Excel.Application COM object from a Python program to open a CSV file and save it as an Excel workbook. If the target file already exists, then I am prompted with this message: "A file named '...' already exists in this location. Do you want to replace it?" That message comes up despite the fact that I have set the XlSav...