Excel File Import Error

2 messages 2 people Latest: Nov 30, 2005

Excel File Import Error

From: Manoj Khurana Date: November 29, 2005 technical
From: MANOJ KHURANA manoj2570@yahoo.com Subject: [NMusers] Excel File Import Error Date: Tue, 29 Nov 2005 13:46:11 -0800 (PST) Hi All, I am using PDx-pop and facing a problem with a datafile (~45000 rows). The edit data option of the PDx-Pop works but View/Datacheckout doesnot as it gives "Error Importing File: 6". NONMEM run using the file is successful but I cannot view output file using excel plotter as it gives the same error msg. Does anyone have a suggestion for this issue. Thanks Manoj Khurana

Re: Excel File Import Error

From: Paul Matthias Diderichsen Date: November 30, 2005 technical
From: Paul Matthias Diderichsen pmdi@novonordisk.com Subject: Re: [NMusers] Excel File Import Error Date: Wed, 30 Nov 2005 09:01:17 +0100 Dear Manoj, Could you provide a few lines of the datafile? You can mask out some digits, eg. YY.XXX (but only change numbers 0-9!), if data are sensitive. My (humble) guess would be problem with eiter "." being exchanged for "," (separator vs. floating point) or probs related to quoting character strings. My experience is, that XL (at least) sometimes manages to mess these things up good. Ultimately, there could be a problem related to character encoding as well (eg. UTF-8 vs. ISO-8859-1). Kind regards, Paul M. Diderichsen. _______________________________________________________