Home Forums FDTD copy data into text or excel

copy data into text or excel

(joined March 2020)
Participant

Hi
I am unable to copy my data from f2d or f3d file into excel or text. When i open f2d file in excel it appears as one column. How can i select it as a separate column one by one?

Responses (3):

    • #67405
      Jawaduddin Abro
      Participant

      Hi
      I am unable to copy my data from f2d or f3d file into excel or text. When i open f2d file in excel it appears as one column. How can i select it as a separate column one by one?

    • #67492
      Profile Photo
      Scott Newman
      Moderator

      Jawaduddin,

      For f2d files, under the Data heading in Excel you will find an Icon for Text to Columns which will allow you to convert that one column into the 2 that are needed.

      f3d files are a bit more complicated as they are a single column and need to be a 2D array based on the dimensions of your design. Usually I use the ReShape function in Matlab. You could build one yourself in Excel using their VBA scripting language which can be accessed using Alt-F11.

      Scott

    • #67500
      Jawaduddin Abro
      Participant

      Hi Scott
      Thank you for your reply,
      Under the observation line, how can i find the reflection spectrum versus wavelength? The observation line file .f2d is attached. This is placed behind the input field.
      Thank you.

    • #67650
      Profile Photo
      Scott Newman
      Moderator

      Jawaduddin, it is not in the f2d file it is in the analyzer window either in the toolbar or under Tools -> Power Spectrum.

Login You must be logged in to reply to this topic.