Group Abstract Group Abstract

Message Boards Message Boards

Can the Cloud Kernel import a XL file?

Pieter van Bijnen
Posted 12 years ago
POSTED BY: Pieter van Bijnen
3 Replies
Sort By:

For Mathematica in a desktop machine, this ReinstallJava method is documented, in a fashion, in
http://support.wolfram.com/kb/12500 and
http://support.wolfram.com/kb/12428 .
POSTED BY: Bruce Miller

Hallo Pieter, sure it works. You just have to realize that the cloud is on Linux somewhere and probably the default settings for InstallJava are just too restrictive. This simple trick (which really Wolfram should include in their aging documentation very very soon, for the long awaited 10.0.3 update which hopefully fixes other urgent (slowdown) bugs) just works for me:

CloudEvaluate[
 JLink`ReinstallJava[JVMArguments -> "-Xmx2048m"];
 Import["test.xlsx"]
 ]
POSTED BY: Rolf Mertig

Rolf,

Thanks for the solution. It solved the issue but not without error messages:

A Java exception occurred: java.lang.ClassCastException: com.wolfram.jlink.JLinkSecurityManager cannot be cast to com.wolfram.jlink.JLinkCloudSecurityManager.

and when used in a Scheduled task in the cloud the logfile produces:

LinkObject::linkn: Argument LinkObject[g4akge2_ipq, 70, 1] in LinkWrite[LinkObject[g4akge2_ipq, 70, 1], CallPacket[CloudSystemPrivateServiceDispatch[CloudSystemUtilitiesPrivate`iFileNameToURL[ etcetera.

Maybe someone from Wolfram can recommend the "designed" way to read a xl file by cloud evaluation.
POSTED BY: Pieter van Bijnen
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Tag limit exceeded
Note: Only the first five people you tag will receive an email notification; the other tagged names will appear as links to their profiles.
Reply Preview
Attachments
Remove
or Discard