***** To join INSNA, visit http://www.insna.org *****
Have you tried copy-paste from Excel to the UCINET's Spreadsheet view
(select Data->Spreadsheets) and saving then this file as UCINET file
On 1/9/06, Maksim Tsvetovat <[log in to unmask]> wrote:
> ***** To join INSNA, visit http://www.insna.org *****
> > I am trying to convert affiliation matrix from EXCELL into UCINET6. The
> > program does not do it. What could be the reason for it ? I have varying
> > sizes of matrices , some of them are 1200 actors x 300 events, but the
> > smaller (145X49) are not converted as well.
> Excel filter seems to depend on certain Microsoft-isms that no longer
> exist in modern
> versions of MS Office; exporting Excel into an older format (Excel
> '97) might help but most
> likely will not - it looks like certain "features" in the format were
> "fixed" by MS.
> I would suggest exporting to a text file (CSV) and importing that -
> or, if all else fails, exporting
> to a text file, writing DL headers by hand and importing the resulting
> DL file (see manual for
> DL format).
> Yes, this is a pain. And a bug in the software. Steve Borgatti, can
> you hear us? :-)
> SOCNET is a service of INSNA, the professional association for social
> network researchers (http://www.insna.org). To unsubscribe, send
> an email message to [log in to unmask] containing the line
> UNSUBSCRIBE SOCNET in the body of the message.
SOCNET is a service of INSNA, the professional association for social
network researchers (http://www.insna.org). To unsubscribe, send
an email message to [log in to unmask] containing the line
UNSUBSCRIBE SOCNET in the body of the message.