Hi,
 
  I have tried this for not importing the first line from excel through 
dataport but it is giving the same error of first line.Kindly suugest wat 
modification should i do
Thanks in advance
Kapil 



----- Original Message ----
From: navisionguy <[EMAIL PROTECTED]>
To: [email protected]
Sent: Friday, 13 June, 2008 11:40:07 PM
Subject: [Navision-Knowledge-Village] Re: Problem In Importing Data from Excel


In order to not import the first line , you bassicaly need to skip
that line. You can do this with C\AL Code that you must insert in your
dataport object.

Step 1) Define a counter variable of type int.
Step 2) In your OnPreDataItem( ) triger put a line to increment the
variable counter: counter := counter + 1;
Step 3) Again in OnPreDataItem( ) put the following code:
If (counter = 1) then
CurrDataport. SKIP;

This will always should skip the first line from your import file.


--- In Navision-Knowledge- [EMAIL PROTECTED] ups.com, kapil kumar
<kapil72002@ ...> wrote:
>
> Hi Group,
> &nbsp; I have a problem that while we import data from excel thru
dataport we make excel in ".csv." format and have to delete the first
line on excel file in which heading of fields are printed.
> &nbsp;
> Is there any way in which we dont have to delete the header of exel
file and data get imported.
> &nbsp;
> Thanks in advance
> &nbsp;
> Kapil Kumar
> 
> 
> Bollywood, fun, friendship, sports and more. You name it, we
have it on http://in.promos. yahoo.com/ groups/bestofyah oo/
> 
> [Non-text portions of this message have been removed]
>

 


      Best Jokes, Best Friends, Best Food and more. Go to 
http://in.promos.yahoo.com/groups/bestofyahoo/

[Non-text portions of this message have been removed]

Reply via email to