Re : Transformer un .csv en .xls + conversion des données.
Bonjour et Merci d'avoir passé du temps sur mon problème !!
Ca fonctionne à quelques détails prèts:
Les lignes des fichiers csv contiennent des chaines de caractères séparées par des "," et le fichier XL qui se crée quand on fait tourner la macro ne ramène que la première suite de caractères avant la première virgule.
ex:
ligne d'un fichier csv :
2000.12.20,00:00,0.89500,0.91050,0.89410,0.90860,193
ligne du fichier XL:
2000,12,20
Le résultat recherché est (pour une ligne) :
colonne1: 2000.12.20 ( points ou virgule, peu importe)
colonne2: 00:00
colonne3:0,89500
colonne4:0,91050
colonne5:0,89410
colonne6: 0,90860
colonne7:193
J'ai regardé le programme de la macro mais je n'y comprends vraiment rien. Il faudrait que je m'y mette.
Voici l'extrait d'un csv si besoin:
2000.12.20,00:00,0.89500,0.91050,0.89410,0.90860,193
2000.12.21,00:00,0.90860,0.91750,0.90540,0.91580,171
2000.12.22,00:00,0.91580,0.92680,0.91410,0.92370,176
2000.12.25,00:00,0.92250,0.92850,0.91950,0.92570,149
2000.12.26,00:00,0.92560,0.93320,0.92320,0.93000,157
2000.12.27,00:00,0.93060,0.93470,0.92710,0.93150,144
2000.12.28,00:00,0.93060,0.93250,0.92420,0.93010,162
2000.12.29,00:00,0.92910,0.94330,0.92750,0.94260,182
2001.01.01,00:00,0.94240,0.94260,0.94040,0.94110,501
2001.01.02,00:00,0.94210,0.95230,0.93650,0.95110,227
2001.01.03,00:00,0.95060,0.95780,0.92600,0.92750,406
2001.01.04,00:00,0.92740,0.95250,0.92660,0.95020,291
2001.01.05,00:00,0.95060,0.95990,0.94610,0.95790,204
2001.01.08,00:00,0.95820,0.95950,0.94590,0.94780,169
2001.01.09,00:00,0.94720,0.94840,0.93810,0.94350,170
2001.01.10,00:00,0.94350,0.94700,0.93570,0.93750,167
2001.01.11,00:00,0.93710,0.95640,0.93600,0.95270,253
2001.01.12,00:00,0.95220,0.95850,0.94650,0.95220,241
2001.01.15,00:00,0.95220,0.95320,0.94070,0.94250,154
2001.01.16,00:00,0.94150,0.94490,0.93680,0.94170,161
2001.01.17,00:00,0.94220,0.94540,0.92840,0.93670,286
2001.01.18,00:00,0.93580,0.94750,0.93500,0.94290,180
2001.01.19,00:00,0.94250,0.95130,0.93290,0.93480,292
2001.01.22,00:00,0.93450,0.94100,0.92650,0.93910,245
2001.01.23,00:00,0.93840,0.94570,0.93410,0.93490,198
2001.01.24,00:00,0.93450,0.93800,0.92070,0.92460,248
2001.01.25,00:00,0.92380,0.92570,0.91130,0.92470,280
2001.01.26,00:00,0.92460,0.93220,0.91950,0.92490,252
2001.01.29,00:00,0.92350,0.92660,0.91550,0.91750,163
2001.01.30,00:00,0.91700,0.92860,0.91420,0.92660,193
2001.01.31,00:00,0.92630,0.93830,0.92500,0.93790,151
2001.02.01,00:00,0.93750,0.94510,0.93610,0.93750,181
2001.02.02,00:00,0.93710,0.94280,0.93140,0.93650,223
2001.02.05,00:00,0.93510,0.94470,0.93500,0.93830,163
2001.02.06,00:00,0.93790,0.93910,0.92780,0.93160,164
Encore merci de ton temps.