muRata Excel Add-in Usage Software-fig8

muRata Excel Add-in Usage Software

muRata Excel Add-in Usage Software-fig6

 

Overview of Product Information Excel Add-in

  • This is an Excel function which returns a portion of the latest information including the status, specification, and URL, etc. for our products.
  • The API key, part number, and language specification are required as input parameters referenced by the function.
  • This Excel function returns information resulting from a search for one part number. Please note that characters such as ‘|’, ‘*’, and ‘?’ cannot be used in the part number.
  • The operating environment is as follows. (Operation in environments other than that described below is not guaranteed)
    • OS : Windows10
    • Excel : Excel 2013, Excel 2016 (Windows version only. Excel online is not supported)
  • list of custom Excel function

    muRata Excel Add-in Usage Software-fig2

Excel Add-in registration

Click “File > Options > Add-ins > Settings > Browse” to register the downloaded Excel Add-in file (Murata Excel Add-in.xll).

muRata Excel Add-in Usage Software-fig3

muRata Excel Add-in Usage Software-fig4

Excel function selection

Enter “=MURATA” in the cell and select the function of the corresponding information item from the function list which is displayed.

muRata Excel Add-in Usage Software-fig5

Argument setting

After selecting the function, click the Function Wizard (fx) to display the argument guide.

muRata Excel Add-in Usage Software-fig6

When the cell of each argument is configured, the input value and output value are displayed.

muRata Excel Add-in Usage Software-fig7

Product information retrieval verification

The output value is displayed in the Excel worksheet.

muRata Excel Add-in Usage Software-fig8

Documents / Resources

muRata Excel Add-in Usage Software [pdf] User Manual
Excel Add-in Usage Software, Excel Add-in Usage, Software

References

Leave a comment

Your email address will not be published. Required fields are marked *