I have an Application that need to evaluate Excel Logical Formulas and I use Excel DLL to do this, but DLL isn't it very efficient. .NET Framework (C#) has any Class that can make this Job? An sample I Provide this =IF(AND(10>=-5;10<0);(-3,8*10+335);IF(AND(10>=0;10<5);(1,4*10+335);IF(AND(10>=5;10<14,4);(-1,2766*10+348,38);IF(AND(10>...
I have an Excel VBA macro which I need to run when accessing the file from a batch file, but not every time I open it (hence not using the open file event). Is there a way to run the macro from the command line or batch file? I'm not familiar with such a command. Assume a Windows NT environment. ...
I've been doing some research on statistical significance, and I've learned a lot but seem to have hit a wall when it comes to calculating P values. I feel like I'm about 95% of the way there; it's just that everything I read on calculating P values references a table rather than offering a programmatic solution. It seems that Excel's ...
Hello, I need to remove the password protection from an uploaded excel file. I have been doing this directly with the Excel assemblies (ASP.NET/C#) and then I tried with the ooxmlcrypto, both worked, but the problem is that I can not deploy either of those solution because of the dependencies. I mean, my sysadmin does not want us inst...
Hi everyone! I am trying to import a text file into excel (2007). The file was exported from a C# text box and it contains linebreaks. Although when I import it (with the text import wizard that comes with excel), the linebreaks disappears completely. I would prefer not to have to write a VBA file and place in an excel file to run but i...
We're currently using a thing from SoftArtisans to generate Excel spreadsheets from data the mainframe FTPs down to our document server. The doc server has the .Net frameworks through 3.5 on it, as does my development box. The difference is my machine has Office 2007 as well. So, I built a service this morning with a filewatcher usi...
Given I have the following <Sheet 1> Item QTY A 5 B 1 C 3 <Sheet 2> Item QTY A 15 B 4 C 1 D 8 What is the best way to generate a report showing the difference between sheet 1 and 2? Like <Difference> Item QTY A 10 B 3 C -2 D 8 ...
Hi , I have an Oracle stored procedure and it has three parameters. I am in confusion to enable this porcedure to Microsoft Excel? Once data are available in Excel, user will make a chart(graph). Can you please give me some samples of code: Stored procedure with parameters, how to connect stored procedure to Excel, Parameter pop in ...
Hello , Is it possible to delete rows in excel sheet using PHP ? Can anyone guide me. Regards, Mithun ...
I generate an XML file through C#, and the relevent part looks like this <ss:Cell> <ss:Data ss:Type="DateTime">2009-01-18T00:00:00.000</ss:Data> </ss:Cell> However it displays in excel as a number , like 41249 that bears no resemblence to the original date. If I right click the cell, and change the format to dd/MM/yyyy or whatever...
Hi guys... I am wanting to try something and I'm fairly sure it's possible, but not really sure!! In MS Excel (2003) can I write a VBA script which will open a location (eg: s://public/marketing/documents/) and list all the documents located within there (filename)? The ultimate goal would be to have the document name, date last modi...
My clients produce lots of data in the form of ad hoc spreadsheets, which they want to upload to their web site and then be able to create online, reports that require joins and filtering of the results. These report should not require any custom coding but will be made with the help of the online platform - the users will be able to cho...
I am interested in using LINQ against Excel. Right now I am using oledb to read a sheet into a datatable and then maybe convert it to list and then I want to manipulate the data and write back to Excel. Seems cumbersome. Is there an easier way using LINQ to do this stuff in a more straightforward way? ...
I need a query that returns subtotals by MemberName(PersonID) but broke out into the 2 different ContactTypes(11 & 12 under IsFaceToFace). The below query gets me the base data I need without any subtotals. I tried messing around with WITH ROLLUP and PARTITION BY but those are new to me and never worked completely right. I am sure I...
I am using Excel to store a list of products, that will be then used to import into a web application. One of the attributes of a product is colour, which is to be selectable from a defined list of colours. The issue is that there can be multiple colours for a product. At present, I am using a dropdown list, which is on each row for a pr...
Given the following data values 12 2 0 -2 -12 I want to add a 3-color scale conditional formatting to the values column such that cells < 0 are green = 0 are white > 0 are red Using formulas like =$A$1<0 for Minimum =$A$1=0 for Midpoint =$A$1>0 for Masximum does not seem to work. cell value > 0 is red, cell < 0 is green, but...
We have a massive spreadsheet which does a lot of calculations and not much drawing / writing to spreadsheets My question is : Does monitoring the spreadsheet whilst it is running via RDP actually make this slower?? Put differently if rdp was disconnected would this result in improved speed?? ...
via Excel 2003 vba I made dsn connection by this method Sub CreateDataSourceFile() Set fso = CreateObject("Scripting.FileSystemObject") Set txtfile = fso.CreateTextFile("C:\program files\Common Files\ODBC\Data Sources\" & Me.cnnName & ".dsn", True) txtfile.WriteLine ("[ODBC]") txtfile.WriteLine ("DBQ=" & Me.DBFolderName)...
I have created my Excel sheet a.xls using Perl where I have field as: date name eid 13/jan/2010 asa 3175 When I will compile next time and if date will be more than previous date then it has to update like wise: date name eid 13/jan/2010 asa 3175 14/jan/2010 stone 3180 If the date will be of pr...
We have an SSAS server with a cube deployed on a server over the WAN.. We are trying to connect to the cube from Excel on various client workstations. The server is not on a domain with the clients. It "works" for some of us but not for others. We are trying and failing yet to determine what the difference is on the machines that wor...