I have to make a excel file from a data base that have around 4000 users.
oh yes sure so i made something like:
open(XLS,">>file.xls");
while (bla bla bla) {
print XLS "$user_name\t\n";
}
close(XLS);
the \t is the tabulation to get it formated into the excel.
My problem is reading just this field($user_name) from the data base the file goes over 70 mb there any possibility of make it around 3 mb or less or something near 10 mb at max ?
oh yes sure so i made something like:
open(XLS,">>file.xls");
while (bla bla bla) {
print XLS "$user_name\t\n";
}
close(XLS);
the \t is the tabulation to get it formated into the excel.
My problem is reading just this field($user_name) from the data base the file goes over 70 mb there any possibility of make it around 3 mb or less or something near 10 mb at max ?
omg i hate excel can some 1 give me a light