9

If the points were regularly spaced you could use Datarange: ListPlot[{28, 32, 37, 66}, DataRange -> {300, 1440}] However, they aren't spaced regularly, so in one way or another you have to specify the x values. Like this, for instance: ListPlot[Transpose[{{300, 600, 1200, 1440}, {28, 32, 37, 66}}]] BTW ExcelLink is not really necessary to get data ...


8

In the Excel object model, the worksheet symbol Cells represents a property, not a method. In Visual Basic and other languages, many properties have a default method called Item. NETLink does not fully implement this notion of a default method: ws@Cells[3, 3]@Value (* 3 *) but: $i = 3; ws@Cells[$i, $i]@Value (* (NETLink`Objects`NETObject$1412516038$...


5

It works with code. Scan[(ws@Cells[#, #]@Value = #*100) &, Range@10] It seems that vars i in ws@Cells[i, i]@Value be not evaluated immediately when the loop goes. I wonder is it a bug in NETLink package? Update v1: (ws@Cells[#, #]@Value = #*100) & /@ (Range@10); Update v2 using Range to fill values faster content = Table[i*j,{i,1,100},{j,1,100}]...


4

The crux of the issue is that the symbol WorksheetClass.Pictures is a method, not a property. When using NETLink, methods must always be followed by an argument list, even when no arguments are being specified. We can distinguish between methods and properties by inspecting the NETTypeInfo: NETTypeInfo["Microsoft.Office.Interop.Excel.WorksheetClass"] ...


4

Using Mathematica's Time-Series framework If you have imported or entered data as tuples (e.g. $\Big\{(time_1,value_1), (time_2,value_2), \ldots \Big\}$ or as a list of values $\textbf{vals}$ with the corresponding list of times $\textbf{times}$ then the most natural thing to do since Version 10 is to use the Time Series - framework which has made ...


3

If you can't do it with Excel Link you can with NETLink. For example, Needs["NETLink`"] PutIntoExcel[data_List, cell_String, file_String] := Module[{rows, cols, excel, workbook, worksheet, srcRange}, {rows, cols} = Dimensions[data]; NETBlock[ InstallNET[]; excel = CreateCOMObject["Excel.Application"]; If[! NETObjectQ[excel], Return[$Failed], ...


3

I haven't tried the most recent version of ExcelLink, but with the previous versions it was not possible. If you wish to generate formatted Excel tables from Mathematica, one way is to generate XML files with specific header which Excel recognizes as its native XML format called "XML Table". In the following threads I discuss this method (although the ...


2

Changing the Excel macro argument type from String to Variant resolved the error: Sub macro1(str As Variant) Range("A1").Value = str End Sub


2

Turning @ilian's comment into an answer: This is a bug, which has been fixed in the development version. For 10.1.0, you may contact support@wolfram.com for a modified ExcelLink.m file, or use the patch from http://community.wolfram.com/groups/-/m/t/472231


2

I don't understand why, but If I put the ExcelLink Function outside of PopupMenu, the problem goes away, as seen below:


1

There are two methods. The first is to use the 'InputForm' function on any of your symbolic expressions. You could also, in the long run, try to use the defined functions in Mathematica for the symbols to begin with. In my experience, this is a more robust method. For example, the you posted can be represented with the Sum function. Putting the symbols ...


Only top voted, non community-wiki answers of a minimum length are eligible