Recently, we need import some data from excel to Oracle database. A strange thing confused me. The excel file has a column, for example PhoneNumber, the format is 999999, here are some example data: 123456 234561 345612 456123 561234 612345 000123...
In the actual develpment, we offen encounter such a problem about exporting data to excel or word, especially excel. I can export data to excel from gridview, but i can not apply styles to the excel cell. Last week, i found how to set the style. For example...