Skip to main content

General discussion

Error Help

I'm adding errorhandlers to a series of pre-existing scripts.  These scripts are for analysts with a wide variety of technical ability to use so I'm trying to keep them simple.  One thing I've been unable to find is a list of the properties IDEA makes available for an error object (.number, .description, .WhatElse?).  The two scenarios where I need more information than I have are as follows:

Exporting two or more tables into different sheets in a single xlsx file.

Hi everyone,
I wanted to know if there is any way to export my tables as Excel format (each should be in a separate sheet) into a single Excel file. Tables a, b, and c should be exported as different sheets into an Excel file named "X".
 
Thanks,
 

Question marks appearing when I import Excel spreadsheet into IDEA

Hello,
I converted a xls file to xlsx file to import itnto IDEA. It seems IDEA does not support xls, right?
Then, I tried to import xlsx (Excel 2016) but question marks appear at the beginning and end of each string (character) cell!
How can I import the data without having question marks?
Please see the images