Murata Excel Add-in Usage User manual

Murata
Brand
Murata
Model
Excel Add-in Usage
Type
User manual

Murata Excel Add-in Usage

Murata Excel Add-in is a powerful tool that allows you to easily access product information from Murata Manufacturing Co., Ltd. With this add-in, you can quickly and easily retrieve the latest status, specifications, and URLs for our products.

The add-in is compatible with Excel 2013 and Excel 2016 (Windows version only) and can be installed by clicking "File > Options > Add-ins > Settings > Browse" and selecting the downloaded Excel Add-in file (Murata Excel Add-in.xll).

Once installed, you can access the add-in's functions by entering "=MURATA" in a cell and selecting the desired function from the displayed list. The add-in supports a variety of functions, including:

Murata Excel Add-in Usage

Murata Excel Add-in is a powerful tool that allows you to easily access product information from Murata Manufacturing Co., Ltd. With this add-in, you can quickly and easily retrieve the latest status, specifications, and URLs for our products.

The add-in is compatible with Excel 2013 and Excel 2016 (Windows version only) and can be installed by clicking "File > Options > Add-ins > Settings > Browse" and selecting the downloaded Excel Add-in file (Murata Excel Add-in.xll).

Once installed, you can access the add-in's functions by entering "=MURATA" in a cell and selecting the desired function from the displayed list. The add-in supports a variety of functions, including:

1
1Copyright © 2020 Murata Manufacturing Co., Ltd. & Accenture Japan Ltd. All rights reserved.
Product Information
Excel Add-in Usage Manual
2
Copyright © 2020 Murata Manufacturing Co., Ltd. & Accenture Japan Ltd. All rights reserved.
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 functions
Function names
Retrievable items
Ceramic Capacitors
Inductors
MURATA_GET_PRODUCTION_STATUS
Status
〇
〇
MURATA_GET_SIZECODEININCH
Size Code Inch
〇
〇
MURATA_GET_CAPACITANCE
Capacitance Text
〇
MURATA_GET_RATEDVOLTAGE
Rated Voltage Text
〇
MURATA_GET_TEMPECHARACTERISTICS
Temperature Characteristics
〇
MURATA_GET_LEADSPACE
Lead Space Text
〇
MURATA_GET_INDUCTANCE
Inductance Text 〇
MURATA_GET_RATEDCURRENT
Rated Current Text 〇
MURATA_GET_RATEDCURRENT_ITEMP
Rated Current(Itemp) Text 〇
MURATA_GET_RATEDCURRENT_ISAT
Rated Current(Isat) Text 〇
MURATA_GET_PRODUCTDETAILURL
Product Detail URL
〇
〇
MURATA_GET_ADDSAMPLECARTURL
Sample Request URL
〇
〇
3
Copyright © 2020 Murata Manufacturing Co., Ltd. & Accenture Japan Ltd. All rights reserved.
1. Excel Add-in registration
•Click "File > Options > Add-ins > Settings > Browse" to register the downloaded
Excel Add-in file (Murata Excel Add-in.xll).
①
②
③
4
Copyright © 2020 Murata Manufacturing Co., Ltd. & Accenture Japan Ltd. All rights reserved.
1. Excel Add-in registration
•Click "File > Options > Add-ins > Settings > Browse" to register the downloaded
Excel Add-in file (Murata Excel Add-in.xll).
④
Select either the 32-bit or 64-bit file
⑤
5
Copyright © 2020 Murata Manufacturing Co., Ltd. & Accenture Japan Ltd. All rights reserved.
2. Excel function selection
•Enter "=MURATA" in the cell and select the function of the corresponding
information item from the function list which is displayed.
6
Copyright © 2020 Murata Manufacturing Co., Ltd. & Accenture Japan Ltd. All rights reserved.
3. Argument setting
•After selecting the function, click the Function Wizard (fx) to display the
argument guide.
Explanation of the
selected argument
①
7
Copyright © 2020 Murata Manufacturing Co., Ltd. & Accenture Japan Ltd. All rights reserved.
3. Argument setting
Input
value
•When the cell of each argument is configured, the input value and output value
are displayed.
Output
value
②
③
=Function name ({API Key}, {Part Number}, {Language})
8
Copyright © 2020 Murata Manufacturing Co., Ltd. & Accenture Japan Ltd. All rights reserved.
4. Product information retrieval verification
Output
value
•The output value is displayed in the Excel worksheet.
  • Page 1 1
  • Page 2 2
  • Page 3 3
  • Page 4 4
  • Page 5 5
  • Page 6 6
  • Page 7 7
  • Page 8 8

Murata Excel Add-in Usage User manual

Murata
Brand
Murata
Model
Excel Add-in Usage
Type
User manual

Murata Excel Add-in Usage

Murata Excel Add-in is a powerful tool that allows you to easily access product information from Murata Manufacturing Co., Ltd. With this add-in, you can quickly and easily retrieve the latest status, specifications, and URLs for our products.

The add-in is compatible with Excel 2013 and Excel 2016 (Windows version only) and can be installed by clicking "File > Options > Add-ins > Settings > Browse" and selecting the downloaded Excel Add-in file (Murata Excel Add-in.xll).

Once installed, you can access the add-in's functions by entering "=MURATA" in a cell and selecting the desired function from the displayed list. The add-in supports a variety of functions, including:

Download PDF
report

Ask a question and I''ll find the answer in the document

Finding information in a document is now easier with AI

Related papers

Other documents