How do I use Mathematica computation of special functions in Microsoft Excel computation?

I have a model equation which I find somehow easier to compute with some experimental data in Microsoft Excel. I had an initial model which is basically a Bessel function. In Mathematica, I was able to compute the model equation with this code:

With[{s = {i, 0, 15, 0.5}}, Table[{i^2, i^3, BesselJ[i, 5.2]}, s]] 

I was as well able to compute the model for experimental data without smooth ranges. The current model is essentially a Legendre equation which I could not find in the Excel formula bar. The challenge I have with the current model is that I have experimental data (of 300 rows) which do not have smooth ranges and I need to use them to determine the model function using Legendre function (a special function). Hence, is it possible to use the incredible computational power of Wolfram Mathematica within the formula bar of Excel or vice versa? Your kind suggestions would be greatly appreciated.

Properly Exporting Data to Excel

I have been looking at wind speed data from various locations. And I’d like to export this to excel. That part works. But what I end up with is a set of data from A1 to XXXX??? Essentially the first row.

Since this data comes with dates, and wind speed data, I was curious if there’s a way to make this export more readable, without transposing and deleting rows. Any thoughts?

How export list in excel file

I want to create a button that exports specific list into the excel file. But when I do it I always get the same error:

Error List does not exist. The page you selected contains a list that does not exist. It may have been deleted by another use

How can it be possible? List exists, because I get id from object model so I should get a NullReferenceException otherwise. Here is my code:

<input type="button" onclick="window.location.href='<%= ExcelUrl %>';" value ="Export data"/> 

code:

    protected override void OnPreRender(EventArgs e)     {         string listName = Lang.Localize("xxx", "List_Measures");         using (var site = new SPSite(SPContext.Current.Site.ID))         using (var web = site.OpenWeb(SPContext.Current.Web.ID))         {             var list = web.Lists[listName];             const string relativeUrlMask = @"_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={0}&View={1}&CacheControl=1";                             ExcelUrl = new Uri(new Uri(site.Url), string.Format(relativeUrlMask, list.ID.ToString("B"), list.DefaultView.ID.ToString("B"))).AbsoluteUri;         }         base.OnPreRender(e);     } 

finally I get an url:

http://mysite/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List=%7B27f5c5b6-e01d-4951-8be5-b31a72eda0e2%7D&View=%7Be518453d-c622-4f31-a0e7-09179f67dce3%7D&CacheControl=1

and it throws this exception. How make it work?


usage of web.Url instead of site.Url doesn’t work


Now i get correct url, but have another problem: it says that I have not enough permissions event if I’m logged under System account. How can it be actually possible?..

Excel Sheet Read-Only

we have an issue that the user once clicked on the excel/word/PPT file it opens as Read Only, the changes made on the file can not be saved to the original file located on the SharePoint library !! but when you open the file uploaded on the SharePoint from the using “open with Explorer” you can edit the file and save the changes. Any one can assist? enter image description here