Import Dates with data loop and CSV
- 5 years ago
I made a small Workaround now and my Problem is done with it.
function Excel_Loop()
{
//Runs the "EXCEL" tested application.
TestedApps.EXCEL.Run(1, true);
Project.Variables.csv2207.Reset();
for(; !Project.Variables.csv2207.IsEOF();)
{
csvimporttest = Project.Variables.csv2207.Value("F5");
test123 = String(Project.Variables.csv2207.Value("F5"));
laengecsv = test123.length;
if (laengecsv < 8 {
csvimporttest = "kleiner 8" + " 0" + Project.Variables.csv2207.Value("F5") + " " + laengecsv
}
else {
csvimporttest = "größer 7" + " " + Project.Variables.csv2207.Value("F5") + " " + laengecsv
}
//csvimporttest = Project.Variables.csv2207.Value("F5") + " " + laengecsv
//csvimporttest = "Test123" + Project.Variables.csv2207.Value("F5")
Aliases.EXCEL.wndXLMAIN.XLDESK.Mappe1.Keys(csvimporttest);
Aliases.EXCEL.wndXLMAIN.XLDESK.EXCEL6.Keys("[Enter]");
Project.Variables.csv2207.Next();
}
}
I imported the data as before but then i watched at the length of the importet value and added a leading 0 when the length is 7.
Thanks for your Replys