Formating Excel sheet by VB.Net
-
Hi All, I have a table (tblEmp) from which I am exporting data to a excel sheet.The table contains 5 fields(empid,empname,age,address,accountno) Issue: Now I want that when ever I export the data from tblEmp table , the accountno field should come as **** in the excel sheet Please let me know how can I do this by vb.net. Thanks in advance.
Pradip Kishore
-
Hi All, I have a table (tblEmp) from which I am exporting data to a excel sheet.The table contains 5 fields(empid,empname,age,address,accountno) Issue: Now I want that when ever I export the data from tblEmp table , the accountno field should come as **** in the excel sheet Please let me know how can I do this by vb.net. Thanks in advance.
Pradip Kishore
AFIAK, there is no built in way to do that. You could do a
for eachon the string char array, and replace each char with an asterisk. Also, you could take a look at the getpass module. And there is always google, for such a simple problem.I'm going to become rich when I create a device that allows me to punch people in the face over the internet. "If an Indian asked a programming question in the forest, would it still be urgent?" - John Simmons / outlaw programmer