Created by Alexander Melnik (ax.melnik@gmail.com), Viacheslav N. Mezentsev (viacheslavmezentsev@ya.ru) in the scope of SMath project. Published by уни.
This is Open Source project. Sources shared under MIT Licence and available in public SVN repository.

This website uses cookies to enhance your browsing experience and provide personalized recommendations. By continuing to use our website, you agree to our Privacy Policy.

Accept

Features of EXCEL I/O with recalculation and PNG export

Version 2.1.8225.33551

Functions

Additional components that add new mathematical functions to the SMath Studio program, necessary for solving problems from various fields.

  1. excel("symbolicExpression")
    (cmd|link) read/write cells
  2. excel("1:symbolicExpression", "2:symbolicExpression")
    (value,link) read/write cells
  3. excel_EMF("1:symbolicExpression", "2:symbolicExpression", "3:symbolicExpression", "4:number")
    (file,sheet,outrange,renderopt:0-1)
  4. excel_IN("1:symbolicExpression", "2:symbolicExpression", "3:symbolicExpression", "4:symbolicExpression", "5:symbolicExpression")
    (save:(yes|no),file,sheet,inpcell,value)
  5. excel_IO("1:symbolicExpression", "2:symbolicExpression", "3:symbolicExpression", "4:symbolicExpression", "5:symbolicExpression")
    (file,sheet,inpcell,value,outrange)
  6. excel_OUT("1:symbolicExpression", "2:symbolicExpression", "3:symbolicExpression")
    (file,sheet,value)
  7. excel_PNG("1:symbolicExpression", "2:symbolicExpression", "3:symbolicExpression", "4:symbolicExpression", "5:number")
    (file,sheet,outrange,pngpath,renderopt:0-3)
  8. excel_PNGv0("1:symbolicExpression", "2:symbolicExpression", "3:symbolicExpression", "4:symbolicExpression")
    (file,sheet,outrange,pngpath)
  9. excel_PNGv2("1:symbolicExpression", "2:symbolicExpression", "3:symbolicExpression", "4:symbolicExpression")
    (file,sheet,outrange,pngpath)
  10. excel_QUIT("1:symbolicExpression", "2:symbolicExpression", "3:symbolicExpression")
    (close:(yes|no),quit:(yes|no),file
  11. excel_VISIBLE("string")
    (visible:(yes|no))
  12. readCell("1:string", "2:symbolicExpression", "3:symbolicExpression", "4:symbolicExpression")
    (file,sheet,row,col) imports data from the Excel cell.
  13. readCell("1:string", "2:symbolicExpression", "3:symbolicExpression", "4:symbolicExpression", "5:symbolicExpression")
    (file,sheet,row,col,keep) imports data from the Excel cell.
  14. writeCell("1:symbolicExpression", "2:symbolicExpression", "3:symbolicExpression", "4:symbolicExpression", "5:symbolicExpression")
    (value,file,sheet,row,column) exports data to the Excel cell.
  15. writeCell("1:symbolicExpression", "2:symbolicExpression", "3:symbolicExpression", "4:symbolicExpression", "5:symbolicExpression", "6:symbolicExpression")
    (value,file,sheet,row,column,keep) exports data to the Excel cell.