hi all, i am importing data from excel sheet to a view.but i want to restrict importing data from those excel sheet which are converted into excel sheet by changing the .extension.How can i do this??
Subject: import xl sheet
Can u please give somewhat broad idea about your problem>
Regards,
Dev
CLP 6/7.
Subject: RE: import xl sheet
actually,if i change the file name of a text file to something with .xls extension.it will be converted into excel file.so i can import data from the converted file in my application.in that case anybody can enter wrong data.so i want to give permission to import only those file which are only excel files,not converted from any other files.
Subject: RE: import xl sheet
Although you can tell Excel to open any file (even “.pdf” files, for example), Excel will not know how to work with it. The instant you try to operate on the file, you will get an automation error (likely) so as long as you trap it, you should not have any problems.
If you need to open a specific type of file (for example, one that was created based on a particular Excel template “.xlt”) then you may need to do additional checking like checking for a presence of a named range, or a specific signal cell containing some special value.