Hello i am new to matlab and would like your help. i have a program that reads the file. mat. when i read that file to transform vector data matrix and so i need to save it in excel.. In my excel sheet i have some column like bank , branch name ,ifsccode, micr code, address, state,district ,city contact. all data not insert in a single table it insert multiple table like i have a table name bank so all the bank are insert in this table i have state table ,district and city table .. The approach most commonly used to transfer data to an excel workbook is automation. automation gives you the greatest flexibility for specifying the location of your data in the workbook as well as the ability to format the workbook and make various settings at run time..
A little bit simpler than save the data as csv-file and import it into excel, would be to save it just as .xls file. just write a normal text-file with ending .xls. i always use this way if i want to save data and analyse it in excel.. When you save excel data to an existing web page, excel always appends the data to the bottom of the page. to move the excel data to another position on the web page, you can open the web page in a design program, such as microsoft office sharepoint designer, and rearrange the items.. When you move data from excel to access, there are three basic steps to the process. note: furthermore, you can append a lot of data into one table. you can save the import operations, add them as scheduled microsoft outlook tasks, and even use macros to automate the process..
