Product Information Excel Add-in Version 2

Overview

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)

Retrievable items/list of custom Excel functions (ceramic capacitors)
No.	Physical name	Retrievable items	Function names
1	Status	Status	MURATA_GET_PRODUCTION_STATUS
2	SizecodeInch	Size Code Inch	MURATA_GET_SIZECODEININCH
3	CapacitanceText	Capacitance Text	MURATA_GET_CAPACITANCE
4	RatedVoltageText	Rated Voltage Text	MURATA_GET_RATEDVOLTAGE
5	TemperatureCharacteristics	Temperature Characteristics	MURATA_GET_TEMPECHARACTERISTICS
6	LeadSpaceText	Lead Space Text	MURATA_GET_LEADSPACE
7	ProductDetailUrl	Product Detail URL	MURATA_GET_PRODUCTDETAILURL
8	SampleRequestUrl	Sample Request URL	MURATA_GET_ADDSAMPLECARTURL

Retrievable items/list of custom Excel functions (inductors)
No.	Physical name	Retrievable items	Function names
1	Status	Status	MURATA_GET_PRODUCTION_STATUS
2	SizecodeInch	Size Code Inch	MURATA_GET_SIZECODEININCH
3	InductanceText	Inductance Text	MURATA_GET_INDUCTANCE
4	RatedCurrentText	Rated Current Text	MURATA_GET_RATEDCURRENT
5	RatedCurrentItempText	Rated Current(Itemp) Text	MURATA_GET_RATEDCURRENT_ITEMP
6	RatedCurrentIsatText	Rated Current(Isat) Text	MURATA_GET_RATEDCURRENT_ISAT
7	ProductDetailUrl	Product Detail URL	MURATA_GET_PRODUCTDETAILURL
8	SampleRequestUrl	Sample Request URL	MURATA_GET_ADDSAMPLECARTURL

No.	Input
No.	Parameter	Parameter Description	Parameter Example	Required/Optional	Memo	Parameter's description to display
1	apikey	API Key	-	Required	-	API key(Required)
2	partno	Part Number (perfect match)	GRM31CR60J107MEA8L	Required	-	Part number(Required)
3	lang	Language Version	ja/zh/en	Optional	If lang is not specified, the output becomes en by default	Language (Optional, values = ja/zh/en, default = en)

Ceramic capacitors
No.	Output
No.	Return Value	Output Example
1	Status	ja:開発中/zh:开发中/en:Under Development
2	SizecodeInch	1206 (3216M)
3	CapacitanceText	10000pF ±10%
4	RatedVoltageText	10Vdc
5	TemperatureCharacteristics	X7R
6	LeadSpaceText	2.5±0.8mm
7	ProductDetailUrl	ja:https://www.murata.com/ja-jp/products/productdetail?partno=GRM31CD80G107MEA8%23
8	SampleRequestUrl	ja:https://my.murata.com/ja/web/samplerequest/cart-requesthistory?pno=GRM31CD80G107MEA8%23

Inductors
No.	Output
No.	Return Value	Output Example
1	Status	ja:開発中/zh:开发中/en:Under Development
2	SizecodeInch	1206 (3216M)
3	InductanceText	22μH±20%
4	RatedCurrentText	250mA
5	RatedCurrentItempText	430mA
6	RatedCurrentIsatText	340mA
7	ProductDetailUrl	ja:https://www.murata.com/ja-jp/products/productdetail?partno=LQW03AW10NJ00%23
8	SampleRequestUrl	ja:https://my.murata.com/ja/web/samplerequest/cart-requesthistory?pno=LQW03AW10NJ00%23

List of error messages
No.	Description	Message contents
1	If there is no API key	Api key is not set.
2	If there is no part number	Part number is not set.
3	If an invalid language code is specified	Language code is not valid.
4	If the authorization fails	Certification failed. Api key is not valid.
5	If the data retrieval fails	Data acquisition failed.
6	If the part number does not exist	The specified part number is not found.
7	If the part number exists but there is no return value	No data corresponding to the request.
8	If an unusable value is entered in the part number	Part number cannot contain '\|*?-'

Murata Excel Add-in 64bit

Murata Excel Add-in 32bit