Topic "Issue while working with excel files in WinScp"

Author Message
shakuntala
[View user's profile]

Joined: 2016-05-06
Posts: 1
Hi,

We are working with Excel files which get transferred from Windows system to our server in Winscp(version 4.1.7). when we copy files manually to Winscp the date format,text format etc. of few files change than the original files. Again when we manually enter those data in new excel and place again and do not face the problem.
Would like to know if we are missing anything while transferring files from windows to Winscp(Protocol SFTP) which is causing this problem.

Eventually from our end when we convert these excels to CSV we are getting some special characters being appended in few cells of excel.
again has this something to do with files being transferred between 2 different operating system (i.e. windows to Unix)

GUI of our application is Explorer

Thanks,
Shakuntala
Advertisements
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 25015
Location: Prague, Czechia
WinSCP can hardly change a cell format of an Excel file.

How do you even test it? Do you download the file back and re-open it? Or do you download it on a different machine and open it there?
Guest




Hi,

Sorry on not being clear earlier. the format appears same in CSV too. but when picked up from an ETL tool the dates from CSV get converted from dd-mm-yyyy to yy(first 2 digits of year)-mm-dd. One strange behavior is that when we sent a file from mailbox the format dint change but when we copied the same file to our local system and modified few entries and placed again on server it was causing the same problem.

So my suspect is that it must be because of some encoding issue while transferring files.
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 25015
Location: Prague, Czechia
Quote:
when we copied the same file to our local system and modified few entries and placed again on server it was causing the same problem.

These are three steps. Which of them modified the format?
And again, WinSCP won't change a date format. That's just a nonsense.
Advertisements

You can post new topics in this forum






Search Site

What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License