Prev: Converting vector map data to matrix form?
Next: Dicom read&write for RT Structure file
From: bobrics on 17 Jun 2005 17:00
Hello,
I would like to output various formatted data to EXCEL using Matlab.
The preference is to have mixed text and matrix data. Also, it would be
great to be able to set some cells to bold/italic, eventually do some
formatting.

I've searched Maltabcentral and found these 2 useful functions:
xlssheets (creates sheets)
xlswrite (write multiline titles, column headers and then data)
However they are not enough for what I need.

I was thinking about creating a template XLS file and putting keywords
where I want to insert my data. So Matlab would search for them and
place matrix of values (and somehow distribute them into cells so that
different 1-row matrices are all alligned).

Do you know of any funtions that could do that? some sort of search and
place at found location?
If there's another already working method, please let me know as well -
that would be the best timesaving solution.

Regards





http://www.mathworks.com/matlabcentral/fileexchange/loadFileList.do?objectType=search&criteria=excel

From: Michael Robbins on 18 Jun 2005 02:08
> I would like to output various formatted data to EXCEL using
> Matlab. The preference is to have mixed text and matrix data. Also,
it
> would be great to be able to set some cells to bold/italic,
eventually do
> some formatting.
<snip>

If you don't specifically need Excel or if you'd be satisfied with
populating a Spreadsheet or grid object and then saving as an Excel
file, these examples may be helpful:

FILLGRID
<http://www.mathworks.com/matlabcentral/fileexchange/loadFile.do?objectId=7765&objectType=file>


preadsheet
<http://www.mathworks.com/matlabcentral/fileexchange/loadFile.do?objectId=6889&objectType=FILE>


raph_and_table
<http://www.mathworks.com/matlabcentral/fileexchange/loadFile.do?objectId=3477&objectType=FILE>


uestDlgWithGrid
<http://www.mathworks.com/matlabcentral/fileexchange/loadFile.do?objectId=7582&objectType=FILE>
From: bobrics on 20 Jun 2005 17:17
'spreadsheet' looks like a nice code to use

I would like to have Excel file at the end. Will matlab allow me to
save data from Excel ActiveX object inside figure directly to XLS file?
That should be good enough.

Regards

From: bobrics on 30 Jun 2005 11:20
I've looked at the code...
Spreadsheet looks like the best example for me.

If you'll look inside the code, it used FIND(ActCell, 'search_string')
function which returns
'Interface.Microsoft_Office_XP_Web_Components._Range' if there's a
match and [] for no match.

->>>> How would I search throughout the whole document or at least
defined by me range?

For now, I can only select one cell and test whether it matches some
text:
ActCell = get(Spreadsheet1,'ActiveCell');

But that means I'll have to write code to go through each cell and
check values!

Maybe I can select range and call FIND() function for it?


Regards

From: bobrics on 30 Jun 2005 14:22
what command /method should I use to set Font Style of a SPREADSHEET
cell to Bold/Italic... ?

what about background colors?


ActCell = get(Spreadsheet1,'ActiveCell');
get(ActCell)

displays only limited number of properties I can change.. like border,
col width, row width,.. not too much formatting from the first glance

 | 
Pages: 1
Prev: Converting vector map data to matrix form?
Next: Dicom read&write for RT Structure file