I have recently started using JChem for Excel. And now I am facing problem in exporting my data into sdf file.
I have also attached an image of error I received while trying to export the data.
Now it is working fine. The only thing is I had to wait until the Export to File box pops up which takes time.
I'm glad it works fine.
(The screenshot you sent indicates, there wasn't enough memory to execute the operation.)
Previously I have been able to export an excel spread sheet with a single column of structures and other with associated data to an sd file using the export feature. However today when I tried i got an error message
"could not set source worksheet"
The details of the message are here:
Message: Application-defined or object-defined error
StackTrace: at ChemAxon.JChemExcel.ExcelCOM.JChemExcelAdapterClass.GetRangeFormulas(SHEETRANGEINDEX& sriSheetRangeIndex, Object& formulas)
at ChemAxon.JChemExcel.Excel.BaseExcelApplicationAdapter.GetRangeFormulas(WorkbookRangeIndex workbookRangeIndex)
††††š˜(ZZZObject , Object )
at ChemAxon.JChemExcel.Base.ExcelMapper.ExcelOutMapper.set_WorksheetName(String value)
†††ˆŽ•(ZZZObject , Object )
at ChemAxon.JChemExcel.IO.ExportFileModel.set_SelectedWorksheetName(String value)
†††ˆ˜(ZZZObject , Object )
What is my problem and how to fix? Thanks
Which JChem Excel version do you use? Could you pelase send me the file you would like to export and send the reproduction steps?
If the spreadsheet contains confidential data, could you pelase send a simplet one or please send it to my email address [email protected].
I am using the latest version of JChem for Excel I just renewed a few months ago
It would be helpful, if you could send us the exact version of JChemExcel.
Also, I would like to know, that do you have .NET Framework 3.5 SP1 installed?
Or, only .NET 4 installed?
This isssue is closed, Bruce realized that there were too many columns in the spreadsheet.
I asked him for a sample file to check if this issue is an Excel API limitation or we can fix this for 5.10.1 ....
He has not sent it yet.